topic Re: Load field number instead of name in App Development

Load field number instead of name

thierrytt1102 — Sat, 16 Nov 2024 21:34:01 GMT

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

Re: Load field number instead of name

m_woolf — Mon, 21 Jan 2019 14:34:36 GMT

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

Load
A as Field1,
B as Field2,

Re: Load field number instead of name

Anil_Babu_Samineni — Mon, 21 Jan 2019 16:06:37 GMT

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

Re: Load field number instead of name

thierrytt1102 — Mon, 21 Jan 2019 16:55:43 GMT

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

Re: Load field number instead of name

thierrytt1102 — Mon, 21 Jan 2019 16:55:54 GMT

Re: Load field number instead of name

thierrytt1102 — Mon, 21 Jan 2019 17:04:57 GMT

Hi,

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

Thierry