Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
Do you have any suggestion on below query.
I have data like,
Period,Sales
1,10
2,50
And I want data like below throug script only,
Period1,Period2
10,50
I have done it through the loop but I am checking is there any other way without loop as loop is taking lot of time as volume is so high.
-Priya
You could use the The-Generic-Load but it's a quite heavy transformation and if your amounts of data are high it will need some time. Usually is your existing datastructure more suitable for the most scenarios - therefore try to rethink your approach and if you really need such transposing.
- Marcus