Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sudhakaran_abha
Creator
Creator

How to pull dynamic field names in load script

I need to pull data from a data file which will have changing column names.

Example:

NameDeptJobJan 2018Feb 2018Mar 2018Apr 2018May 2018Jun 2018
JohnFinanceJ110020213122121213
BerryTaxJ2100200200200200200
CharlieITJ3200120200200250120
JackFinanceJ4500300200200100300

The first few column names will remain the same, but the Month-Year columns would keep changing because this is a rolling 12 or 15 month file.

What I am trying to achieve is to have a dynamic logic so I can pull all fields (with field names) and also derive month year values from the column headers, to later use them in the calendar & dates.

NOTE - CROSSTABLE might not be the answer, because the user wants to see a separate column for each month.

Any help is appreciated. Thanks

1 Reply
sunny_talwar

May be load using * instead of using the names of the field

LOAD *

FROM ....;