topic Re: load script without a specific field in QlikView

load script without a specific field

Tue, 24 Nov 2015 10:19:49 GMT

Hi,

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?

Thanks,

Boris

Re: load script without a specific field

tamilarasu — Tue, 24 Nov 2015 10:26:31 GMT

Hi Boris,

You can try below,

Load * From your path...

Drop Field FieldName;

Something like below

Re: load script without a specific field

Tue, 24 Nov 2015 10:31:55 GMT

No way to prevent the initial load of this field? (it is a huge fields, almost sized as the entire table)

Re: load script without a specific field

tamilarasu — Tue, 24 Nov 2015 10:34:52 GMT

I guess, it's not possible. You have to load fields and drop the specific field at the end of the statement.

Re: load script without a specific field

avinashelite — Tue, 24 Nov 2015 10:41:00 GMT

No,without script statements it's not possible.... you need to right the 39 fields or follow TamilArasu approach

Re: load script without a specific field

Peter_Cammaert — Tue, 24 Nov 2015 10:41:54 GMT

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...

Re: load script without a specific field

Tue, 24 Nov 2015 11:16:20 GMT

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?

Re: load script without a specific field

Peter_Cammaert — Tue, 24 Nov 2015 11:22:43 GMT

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.

Re: load script without a specific field

Tue, 24 Nov 2015 11:32:37 GMT

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.