topic Re: Omitting data from a table in App Development

Omitting data from a table

Qlikierick — Fri, 01 Mar 2019 12:28:09 GMT

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.

How can I accomplish this?

Re: Omitting data from a table

Mauritz_SA — Fri, 01 Mar 2019 12:45:00 GMT

Hi there

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.

Regards,

Mauritz

Re: Omitting data from a table

MindaugasBacius — Fri, 01 Mar 2019 12:45:43 GMT

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/SystemVariables/HidePrefix.htm

Re: Omitting data from a table

Qlikierick — Fri, 01 Mar 2019 13:01:42 GMT

Thanks for your answer! But what I want is to simply drop certain rows with certain names, not an entire field.

I tried the "where <> 'datatoomit';" statement, but that didn't work either.

What could I be doing wrong?

Re: Omitting data from a table

Qlikierick — Fri, 01 Mar 2019 13:01:54 GMT

Thanks for your answer!

Re: Omitting data from a table

Qlikierick — Fri, 01 Mar 2019 13:23:08 GMT

I should also say that the error message when I try to reload the data says: "there is no open data connection".

Re: Omitting data from a table

Mauritz_SA — Fri, 01 Mar 2019 13:28:16 GMT

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:

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.

Regards,

Mauritz

Re: Omitting data from a table

Qlikierick — Fri, 01 Mar 2019 14:00:59 GMT

Yes, that's exactly how I wrote my code, so I think there's something wrong with loading the data, as you say. Thanks again!