Hi, I am working with the product codes in the following field:
the issue is: how can I transform these codes (rows) in field to perform gradually some KPI between columns?
How should be done the script?
Based on my understanding, if you have this Field in your data base, you can try to use the transpose in Transformation while Loading..
LOAD @1 as F1,
@2 as F2,
@3 as F3,
@4 as F4,
@5 as F5,
@6 as F6
(ooxml, no labels, table is Sheet2, filters(
Transpose the fields.
Have a look:
Now the resultant table is in the below format
Cutomer, Month, Budget
Hope this helps you.
Hi, thanks a lot for your helpful advice!
Retrieving data ...