Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

load script without a specific field

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

1 Solution

Accepted Solutions
tamilarasu
Not applicable

Re: load script without a specific field

Hi Boris,


You can try below,

Load * From your path...

Drop Field FieldName;


Something like below

Capture.PNG

8 Replies
tamilarasu
Not applicable

Re: load script without a specific field

Hi Boris,


You can try below,

Load * From your path...

Drop Field FieldName;


Something like below

Capture.PNG

Not applicable

Re: load script without a specific field

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

tamilarasu
Not applicable

Re: load script without a specific field

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

avinashelite
Not applicable

Re: load script without a specific field

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

Peter_Cammaert
Not applicable

Re: load script without a specific field

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

Not applicable

Re: load script without a specific field

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?

Peter_Cammaert
Not applicable

Re: load script without a specific field

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.

Not applicable

Re: load script without a specific field

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.