Store Table header as field

[techvarun]

Hi Experts,

I have an excel sheet which has fields with header like below.

31/10/2019

30/11/2019

31/12/2019

31/01/2020

29/02/2020

31/03/2020

30/04/2020

31/05/2020

30/06/2020

31/07/2020

31/08/2020

30/09/2020

Now I need to create a Field called months as below.

Month

31/10/2019

30/11/2019

31/12/2019

31/01/2020

29/02/2020

31/03/2020

30/04/2020

31/05/2020

30/06/2020

31/07/2020

31/08/2020

30/09/2020

How do i achieve this ? Please help

[StarinieriG]

Hi,

when you load the excel, use "enable transformation step", then click on rotate

[docpuddu · Accepted solution]

Ciao,

load from Table file, Excel then (as written above, in the 1st answer) -> Enable Transformation Step -> Rotate

Finally, in the resulting LOAD script  use the Date function to convert dates in the proper format.

Date(@1)

----
Directory;
LOAD
Date(@1)
FROM
row.xlsx
(ooxml, no labels, table is Foglio1, filters(
Rotate(right)
));

HTH.
Ciao,
/A

[Brett_Bleess]

Varun, did either of the two posts get you what you needed?  If so, do not forget to come back to the thread and use the Accept as Solution button on the post(s) that helped to give credit and let others know things worked.  If you are still working on things, leave an update.

Regards,
Brett