Sitemap

Amicuk Programming Answers

Columns To Rows Transpose

-0001-11-30   Views:0

Advertisement

Need some help to display the output data in the below format,Pls help out... Eg: OV:Old Value NV:New Value ID OV NV 1 -- 100 1 100 200 1 200 300 OUTPUT: ID VALUES 1 100 200 300Hi, i think this link helpful to you http://www.club-oracle.com/forums/un

Need some help to display the output data in the below format,Pls help out...
Eg:
OV:Old Value
NV:New Value
ID OV NV
1 -- 100
1 100 200
1 200 300
OUTPUT:
ID VALUES
1 100 200 300

The replay answer
Advertisement
Hi,
i think this link helpful to you
http://www.club-oracle.com/forums/unpivoting-column-to-row-conversion-techniques-sql-t145/

Go to See the other 7 answers

Columns to row transpose

Category:DefaultRelease time:-0001-11-30Views:130

Hi there, Context: I have to run a job weekly which would load (update/insert) DestTable with data from SourceTable, before i load the data into DestTable i have to transform the data which includes transpose Columns to rows based on a composite key[More]

Columns To Rows Transpose

Category:DefaultRelease time:-0001-11-30Views:130

Need some help to display the output data in the below format,Pls help out... Eg: OV:Old Value NV:New Value ID OV NV 1 -- 100 1 100 200 1 200 300 OUTPUT: ID VALUES 1 100 200 300Hi, i think this link helpful to you http://www.club-oracle.com/forums/un[More]

Transpose columns and rows in numbers

Category:DefaultRelease time:-0001-11-30Views:130

I need to transpose columns and rows in Numbers and I do not want to write script to do it.  Is there an easier way?Give me a proper transpose and I will uninstall Excel and never look back. Ok, here's a proper transpose, that can be placed in an Aut[More]

How to transpose columns to rows in ODI

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am trying to transpose Columns to rows along with Headers. For instance if i have Account Name | Assigned To | Lead Source | Currency | Onsite_April |Offisite_April2 | FCST AMC LIC April | | | | | | Microsoft | Mark | Channel1 | INR | 1000 | 20[More]

Transposing columns to rows in excel through ODI

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, We are trying to transpose Columns to rows along with Headers considering excel as source and oracle table as target For example we are having metadata and data in Excel sheet like below Metadata:- A,B,TC1,TD1,L1,U1,TC2,TD2,L2,U2,TC3,TD3,L3,U[More]

Transpose columns to rows

Category:DefaultRelease time:-0001-11-30Views:130

HI All, I want to transpose columns to rows in my reports. I tried through Pivot Table and i was able to do that, but columns name are not appearing in the left. Plz help me out how to do that with column name/ Can we do the same with measure also???[More]

Transpose columns into rows

Category:DefaultRelease time:-0001-11-30Views:130

hi , i need to transpose columns into rows , i know i can use the UNION ALL but my num of columns will most likely not be fixed so how can i do that ? pls adviseThis is from one of the forms link,, i reallyy dont know the link, but i guess this is "a[More]

Transpose of columns to rows (unpivoting) and not rows to columns

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am right now using oracle 10g. I HAVE the following specification. Here I specified only 5 columns. We have upto 200 columns. TRANS_ID      PORTFILIO_NUM     TICKER          PRICE     NUM_SHARES ........................................ 2     10[More]

Transpose columns and rows / Switch columns and rows

Category:DefaultRelease time:-0001-11-30Views:130

Hello, Is it possible to interchange columns and rows in order to create a left-to-right scrolling table instead of a top-to-bottom scrolling one? In detail: I have this:       | col 1 | col 2 | col 3 row 1 |       |       | row 2 |       |       | r[More]

In Numbers, I want to make 3 rows 50 columns into 3 columns 50 rows.

Category:DefaultRelease time:-0001-11-30Views:130

In just a simple Numbers 09 spreadsheet, no charts, I'm trying to convert the rows and columns to columns and rows to more easily work with the information without scrolling across the page.  I would be able to see the information on one page and mor[More]

Reformatting Table- convert columns to rows

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have data tables that I would like to reformat so that the columns become rows and vice versa, if that is possible. I've been keyword searching for hours, but unfortunately I am unfamiliar with the terminology... Sorry if this is really stupid;[More]

Hot
It does not matter if I connect through bt.com or direct to bt mail I get the same error message no matter what computer \ browser or internet connection I use at home work or wirelessly Continue to Yahoo! log in We can't log you into your BT Yahoo! [More]
Hi All, When we are trying to process an Huge IDoc which has large number of segments. The IDoc process starts and stops in the middle and remains in 64 status ( there are no short dumps etc). Currently the IDoc is configured to be Trigger Immediatly [More]
can anyone please answer me this quick question? i have a satellite p10-722 with an s-video out, if i were to connect a normal s-video cable to this then to my tv would i be able to view my laptop on my t.v? thank you for any answersHi If you connect [More]
I have an exe file to install a toolbar that is supposed to be compatible with IE and Firefox. When I install it, IE opens up fine with the toolbar but FF doesn't even show it listed under View- Tolbars.I have an exe file to install a toolbar that is [More]
Posted: Mon Aug 25, 2008 6:32 am Post subject: i really hope no1's experienced what i'm experiencing. Hey guys I've recently purchased myself a DVI to VGA adapter to connect my macbook 13inch to my 17inch LCD it was going smooth for the first couple [More]
Hi We are creating own JMS Queues in our code, and are using the message selector clause to distinguish between the messages. We are using Weblogic version 9.1. Although, this works when it is a standalone application (i.e when have two files to send [More]
Hello, I'm trying to save an image sequentially but in a specific format. Currently, I choose a folder path (the folder all the images will be saved under), the image name, and then the iteration number causes the image to change sequentially with ea [More]
HI, We have ISA installed but I dont know how to check the version of what version of ISA is installed. It's ABAP+JAVA. Can some one help regarding this? I have tried system>>status>... nothing showing about ISA. Your help is really appreciated. [More]
Hi, We are setting up the cash journal and one of the items to customize is the Amount Limit. We set up an amount limit, however the system does not validate the amount when entering or posting documents in the cash journal, Someone knows what is mis [More]
Hi SAP Gurus, In OB08 i created 2 exchange rate Exchange Rate---Valid From---Indirect quotatRatiofrom-direct quo--ratio--to 1. M--01/01/2001N/A1---GBP-1.5000--1--USD 2.M--27/7/20105.100001USDN/A1--GBP Here the co code currency is USD, now when in try [More]