Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Not applicable

Changing Header Column in Excel Data File

I have a particualr column header in an Excel data file that changes weekly (it happens to be the first column, which is the current week). As such, I can't do an auto-load because I have to manually go in and increment the header name. Is there a way to tell QV 11 to ignore the column header name and just pull in whatever is there?  JPT
Safety:
LOAD "18" as BldgWk,
[NON-REC INCIDENT] as [Bldg 1A NR],
[RECORDBLE INCIDENT] as [Bldg 1A R],
[NON-REC INCIDENT1] as [Bldg 1B NR],
[RECORDBLE INCIDENT1] as [Bldg 1B R],
[NON-REC INCIDENT2] as [Bldg 2 NR],
[RECORDBLE INCIDENT2] as [Bldg 2 R],
[NON-REC INCIDENT3] as [Bldg 3 NR],
[RECORDBLE INCIDENT3] as [Bldg 3 R],
[NON-REC INCIDENT4] as [Corporate NR],
[RECORDBLE INCIDENT4] as [Corporate R]
FROM


(

ooxml, embedded labels, header is 4 lines, table is [MGR DATA])
1 Reply
rwunderlich
Not applicable

Changing Header Column in Excel Data File

The easiest way is to remove the "embedded labels" parm and then reference each field with the @n syntax. for example:

LOAD

@1 as BldgWk,

@2 as [Bld 1A NR],

etc

-Rob

Community Browser