Hi! I am trying to omit data in a table I have loaded in my app, but I can't figure out how to do it properly. I have tried editing the script, such as adding the line "set HidePrefix='datatoomit' ;" beneath the LOAD section of the script, but the data still remains in a table that I use in my app.
Do you have a sample of the data in the file and the data you would ideally want? If you want to omit certain rows then you can put it in you where clause under the load and if you want to remove rows you can obviously not use them in the first place in your load statement or you can use DROP FIELDS <FieldName>; after your load.
What do you mean omit data? To remove data from your data models to may: 1. Not load it and select only the fields you need. 2. After using the fields you might Drop them from your data model. 3. To not include some data you can use Where sentence in the back end. 4. If you can HidePrefix variable also might be useful. Read here how to use HidePrefix statement https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Sy...
If you want to omit certain rows then you can use a Where statement, but you need to specify the field/column name that shouldn't have the 'datatomit' value. For example:
LOAD:
x,
y
From Table
WHERE
x <> 'datatomit';
As for the data connection part, try adding the data using the Data Manager and then unlock the script and edit it in the Data Load Editor.
