Solved: Load all fields but a few - Qlik Community

Report Inappropriate Content · ‎2013-03-26

Good morning,

I'm fairly new to Qlikview and still learning about Qlikview script.

I have a table with many fields and I would like to import all of them into a document, but only a few. And I was wondering if it is possible to write something like "LOAD * "EXCEPT" FROM TABLE1"...

Gysbert_Wassenaar · ‎2013-03-26

That's not possible. But with the wizard you can create a load statement that lists all fields. After creating the load statement you can highlight the lines with the fields you don't want and comment them out by right clicking and choosing Comment.

talk is cheap, supply exceeds demand

View solution in original post

Gysbert_Wassenaar · ‎2013-03-26

That's not possible. But with the wizard you can create a load statement that lists all fields. After creating the load statement you can highlight the lines with the fields you don't want and comment them out by right clicking and choosing Comment.

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2013-03-26

Wait, I just thought that my second question was pointless. Thank you for the clarification.