Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Very urgent problem - load 11 lists where one field might be missing in 1?


`Hi,

I have a rather urgent problem: My colleague is not there and I actually have to do something else.

The issue is this:

- There are 11 lists on the server (Excel lists) which are usually equal in structure

- Those are currently loaded in a loop, so that we see which list we have an issue with in case we do.

- Just that is the case now: In one of those 11 lists, one field is just missing.

I have already developed a code to dynamically construct the fieldnames in case they vary - which they do from time to time - but I have no idea how to catch that possibility - that one field is present in 10 of the 11 lists, but not in the last one.

For now, it would perhaps be easier to just insert one field - which I cannot do, I have no RW access - but there has to be a possible long-term solution for this?

Thanks a lot!

Best regards,

DataNibbler

10 Replies
datanibbler
Champion
Champion
Author

Great!

Many thanks!

Of course, it would be much easier - and moreover logical - to go toward the source (that is, the person inputting those lists in the first place which must be the person omitting fields if that is the case) - but I guess our chances of achieving any effect in that way are slim, knowing our customer's company ...

I'll try that.