Load field number instead of name

[thierrytt1102]

Dear, 

When loading fields (names) that might change from a XLSX file, I was used to load these fields with an '@1 as  Field1' in Qlikview but I'd need to do this in QS and I have an error.

Do you know if something changed frmo QV to QS or am I missing something?

Thank you  for your help.

Regards

[m_woolf]

Not sure about Sense, but with QV and .xlsx files, the script would be:

Load
        A as Field1,
        B as Field2,

[Anil_Babu_Samineni]

We even have "Embedded labels" in sense. You can use that.

[thierrytt1102]

Hi, Thx. Embedded labels won't work has it might change and I need integers for qulifying my fields. Otherwise I think I found my problem; A field position is loaded as @1 ... @n with a CSV or XLS. In XLSX, it is only A, B, C, ... Z, AB, BB, .... This means I had first to convert it into CSV , then load it again using my @n. BR Thierry

[thierrytt1102 · Accepted solution]

Hi, Thx. Embedded labels won't work has it might change and I need integers for qulifying my fields. Otherwise I think I found my problem; A field position is loaded as @1 ... @n with a CSV or XLS. In XLSX, it is only A, B, C, ... Z, AB, BB, .... This means I had first to convert it into CSV , then load it again using my @n. BR Thierry

[thierrytt1102]

Hi, 

Thx. Yes it is but I have 2000 fields sometimes well named, sometimes not... 😕 

BR

Thierry