Convert the values from one column to several columns

[beck_bakytbek]

Hi Folks,

i got a situation, my table doesl look like:

Year	Month	Material	Value
2021	1	A1	5
2021	2	A1	10
2021	3	A1	15

and i want to convert this table in the following view:

Year	Material	1	2	3
2021	A1	5	10	15

In this case, is there another possibility (in the script) to convert this table in this way? I know that there is a generic load, but as far as I know, the generic load can cause performance problems.

Does anybody have any idea hot resolve this issue?

Thanks a lot in advance.

Bek

[KetanPatel]

Hi,

Please you could try CrossTable function on your script.

For Example:                      

                              CrossTableLOAD:

                                 crosstable (Month, Material)

                                  LOAD * from ex1.xlsx;

[beck_bakytbek]

Hi @KetanPatel  first of all thanks a lot for responce and time, i tried to implement it within my script, but it does not work (should i use then set expression on UI to make visible my expected output)?

Thanks a lot

Bek