Discussion Board for collaboration on QlikView Scripting.
I have a table with 40 fields.
one of this fields is very large and not needed in the final data model.
I don't want to write a load statement with 39 fields just to remove this 1 field.
any way of doing that?
Solved! Go to Solution.
Why not specify the 39 field names? It's not that you have to type their names yourself... QlikView can do that for you.
There is a good reason to do it that way ('*' should be banned ). Imagine that someone adds another huge field to your data source without telling you. Happens all the time in enterprise envronments (a simple ERP upgrade may add various fields that no-one needs). Consider it a best practice in most cases...
The only issue with this approach that if I build a dynamic model which wants to get new fields I need to go each time to the script and add the field to the script, no?
Well, yes. But how are you going to update the document UI in the same dynamic manner?
Remember that on average complex UI objects won't complain about renamed fields (QV doesn't always get that one right in an automated way) or fields that have simply disappeared. And the end-user may not be aware of the missing pieces until much later.
But of course you're right. It's up to you to make the best choice for your requirements.
currently yes, we do allow new definition of dimensions and measures in our Big data analytics and thus letting the script load all the fields and then dynamically adding this dimensions\measures to our objects.