redefine multiple columns in one field from excel file

[Anonymous]

hello,

how can redefine multiple columns in one field from excel file for example, the column January, February, March in a month field to be able to recover and make calculations?

thank for your responses.

[rubenmarin]

Hi Franck, you can use crosstable to retrieve month as a selectable value:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/ScriptPrefixes/crosstab...

Crosstable (Month, Sales) LOAD * from ex1.csv;

[shiveshsingh]

You can use this before load statement

Crosstable (Month, Sales, "Qualifier Field sequence number")

[Gysbert_Wassenaar]

Note that this will give you months that are just text values. You may want to turn them into formatted dates in a second load statement with something like Date(Date#( MonthFromCrosstable ,'MMM-YY'),'MMM-YY')

[shiveshsingh]

Correct