Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Multiple possible column names for same field?

Greetings,

I have a QVD Generator, which pulls from an excel file that is uploaded periodically. However, some of the columns may be named slightly differently sometimes. So for example, the column name could be "First Column" in some instances or sometimes it could be "First_Column". In either case only one of these columns should exist in the Excel file at any point in time, albeit under a slightly different name. So I want [First Column] or [First_Column] as [First Column]. Please let me know if this is possible.

Thanks in Advance!

4 Replies

Re: Multiple possible column names for same field?

Here is a way to dynamically load all the field names

Re: Multiple possible column names for same field?

You can try with the ALIAS statement. It allows you to define an automatic rename for fields with slightly deviating field names before you load them. For example,

ALIAS [First_Column] as [First Column];

will force an implicit rename in each subsequent LOAD or SELECT. Of course, the script will not automatically detect other new variations on the same field name. Artificial Intelligence is not (yet) built into the script engine .

So whenever you detect a new naming deviation, you 'll have to add it to the corresponding ALIAS statement. If you put all ALIASes in an external script and include that one in every load script, management of field naming becomes very straightforward.

Peter

Re: Multiple possible column names for same field?

I did not know about ALIAS. Thanks for introducing that Peter

Re: Multiple possible column names for same field?

My pleasure.

Community Browser