Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Not sure about Sense, but with QV and .xlsx files, the script would be:
Load
A as Field1,
B as Field2,
We even have "Embedded labels" in sense. You can use that.
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
Hi,
Thx. Yes it is but I have 2000 fields sometimes well named, sometimes not... 😕
BR
Thierry