drop after binary

[Tool_Tip]

Dear all,

Just want to check if we can drop fields after binary load?

for example :

BINARY [lib://Qlik/XXXXXXXXXXXXXXXX45209];

Drop fields 

[REGION_CODE],

[FIRST_NAME],

[SECOND_NAME],

[THIRD_NAME];

Something like this? or we can drop the fields from data model only.

[Rishabh_Chaudhary · Accepted solution]

Yes we can drop the fields after loading a binary data model. 
Since, we are loading all the tables from the different QVF, the tables are there so that we can perform further actions on the loaded model.

[Tool_Tip]

Hi Rishab,

I have tried, Yes we can drop the fields only after the binary statement. If you have something inline table created in between then it is not working.

1) Case 1: working fine 

     binary load......;

     drop fields 

2) Case 2...Not working

     Binary load 

     inline table

    drop fields ...

[marksouzacosta · Accepted solution]

It should work. You can do any script manipulation after the Binary Load, even do Resident Loads from the Binary Loaded tables.

Can you please share your code with us? You may be missing something in your syntax.

[Tool_Tip]

Yes Mark it is working. I realized now that there were ; semicolon were missing after my inline table.