Skip to main content

Water Cooler

This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
flames
Contributor III
Contributor III

Reshape Table or Cross Table ?

This is my input table :

for each row, i need to have 5 lines rows for 5 quarters .

quarter should be a column and it will have quarter info, Value should be another column which have corresponding values in it.

 

FLOCATIONTSIZEDNUMBERMNUMBERBCODE18041901190219031904
MI FB 110MN5618A2B5618A2B5618A2B          -            -            -            -            -  
MI FB 220MN56745HYDAQ356745HYDAQ356745HYDAQ3   1,600   1,100   1,475   1,594   1,501
MI FB 220MN56745HYDAP456745HYDAP456745HYDAP4      650          -        455      787      716
MI FB 220MN56745HYDAE456745HYDAE456745HYDAE4   1,000      349      918   1,178   1,150
MI FB S220MN56745HYDAF956745HYDAF956745HYDAF9      300          -            -            -            -  
MI FB S220MN56745HYDA1A56745HYDAF956745HYDAF9         25      100          -            -            -  
TSMC FAB 1230MN56745HYDQ56745HYDQ56745HYDQ         75          -           21      274      249

 

Need out put table like this..

This is output for only 4 rows of the above table.

 

FLOCATIONTSIZEDNUMBERMNUMBERBCODEQTRValue
MI FB 110MN5618A2B5618A2B5618A2B1804-
MI FB 110MN5618A2B5618A2B5618A2B1901-
MI FB 110MN5618A2B5618A2B5618A2B1902-
MI FB 110MN5618A2B5618A2B5618A2B1903-
MI FB 110MN5618A2B5618A2B5618A2B1904-
MI FB 220MN56745HYDAQ356745HYDAQ356745HYDAQ318041600
MI FB 220MN56745HYDAQ356745HYDAQ356745HYDAQ319011100
MI FB 220MN56745HYDAQ356745HYDAQ356745HYDAQ319021475
MI FB 220MN56745HYDAQ356745HYDAQ356745HYDAQ319031594
MI FB 220MN56745HYDAQ356745HYDAQ356745HYDAQ319041501
MI FB 220MN56745HYDAP456745HYDAP456745HYDAP41804650
MI FB 220MN56745HYDAP456745HYDAP456745HYDAP41901-
MI FB 220MN56745HYDAP456745HYDAP456745HYDAP41902455
MI FB 220MN56745HYDAP456745HYDAP456745HYDAP41903787
MI FB 220MN56745HYDAP456745HYDAP456745HYDAP41904716
MI FB 220MN56745HYDAE456745HYDAE456745HYDAE418041000
MI FB 220MN56745HYDAE456745HYDAE456745HYDAE41901349
MI FB 220MN56745HYDAE456745HYDAE456745HYDAE41902918
MI FB 220MN56745HYDAE456745HYDAE456745HYDAE419031178
MI FB 220MN56745HYDAE456745HYDAE456745HYDAE419041150
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

What do you by reshape table?
Did you try cross table load? This looks ideal
E.g.
Crosstable (QTR,Value,5)
Load
*....

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

What do you by reshape table?
Did you try cross table load? This looks ideal
E.g.
Crosstable (QTR,Value,5)
Load
*....
flames
Contributor III
Contributor III
Author

yeah, Thanks, it worked. 

I remember  'reshape' command in R, so asked a similar kind here, your solution worked anyway, Thanks again.