topic Re: Store Table header as field in QlikView

Store Table header as field

techvarun — Sat, 16 Nov 2024 19:45:33 GMT

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

Re: Store Table header as field

StarinieriG — Tue, 05 Nov 2019 09:03:00 GMT

Hi,

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

Re: Store Table header as field

docpuddu — Tue, 05 Nov 2019 09:31:16 GMT

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

Re: Store Table header as field

Brett_Bleess — Mon, 11 Nov 2019 15:27:29 GMT

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