Script : values from rows to columns (fields)

[#1]

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.

[settu_periasamy]

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()

));

[Anonymous]

Hi,

Transpose the fields.

[Anonymous]

Have a look:

Transpose Table

[jagan]

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.

[#6]

Hi, thanks a lot for your helpful advice!

Best regards,

Flavio