topic Re: Field Name Sensitivity in QlikView

Field Name Sensitivity

Berg_127 — Fri, 15 Nov 2024 22:16:13 GMT

Hallo,

I am struggling with an import script and specifically the field names.

We receive daily field that I need to import into a model. The challenge is that on of the field names changed from "Employee Name" to "Emp Name".

Unfortunately, I cannot disregard the column names as the number of columns tend to differ from file to file. I should note that I don't require the information in the columns that have been added.

The question is, how do I script it to make provision for both field names?

Thanks

Re: Field Name Sensitivity

rwunderlich — Thu, 31 Mar 2022 17:42:45 GMT

Alias "Emp Name" as "Employee Name"

See https://qlikviewcookbook.com/2018/12/loading-varying-column-names/

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Field Name Sensitivity

Berg_127 — Thu, 31 Mar 2022 17:44:19 GMT

Brilliant!!

Thank you, Rob. Really appreciate the help!