Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.
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 ...
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.
Yes Mark it is working. I realized now that there were ; semicolon were missing after my inline table.