adding a new field to excel files as datasource

[TomBond77]

Hi experts

We have 50 excel files as datasource for a Qlik app.

Now there is a new field added to only 5 of these files. Loading the files aborts - this is logical.

How would you oversteer this challenge? I tried this statement in the script:

' ' or "Regular_Temporary" as Regular_Temporary

But it is not working.

Any ideas?

Thanks!

[marcus_sommer · Accepted solution]

The exists of a field couldn't be evaluated within the load. Therefore you need to load the different data-structures with different load-statements.

For this you need to identify the files or pre-loading their data-structure to branch to the appropriate load-statement or to adjust a single load-statement on the fly. It's not very difficult but of course it needs some efforts and adds extra complexity - especially if there are several different versions and more as a single field respectively field-values/formatting needs be considered.

Much more simple is to move each different data-structure in a separate folder and using then for each a separate load-statement. Of course this is a bit redundant but everything remains simple and readable.