Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Best regards,
Flavio.
Hi,
Based on my understanding, if you have this Field in your data base, you can try to use the transpose in Transformation while Loading..
Like
Directory;
LOAD @1 as F1,
@2 as F2,
@3 as F3,
@4 as F4,
@5 as F5,
@6 as F6
FROM
Book1.xlsx
(ooxml, no labels, table is Sheet2, filters(
Transpose()
));
Hi,
Transpose the fields.
Have a look:
Hi,
Try CROSSTABLE()
Example:
Data:
CrossTable(Month, Budget)
LOAD
Customer,
Jan,
Feb,
Mar,
Apr
FROM Budget;
Now the resultant table is in the below format
Cutomer, Month, Budget
Hope this helps you.
Regards,
Jagan.
Hi, thanks a lot for your helpful advice!
Best regards,
Flavio