Delete rows in qlik sense while loading the data

[varma8998]

Hi All,

I want to delete few rows

I have a table in the below format In the data manager

X     Y         Z

1    AAA     1234

2    BBB      5678

3    CCC     91011

4   DDD      121314

but I need the output like this in the data manager not in the charts

X     Y           Z

1   AAA     1234

[JordyWegman · Accepted solution]

Hi Varma,

You can't delete rows, but you can decide not to load them.

In the script you can add the following statement, just before the ';' at the end of the table that is loaded.

Where Y = 'AAA'

Jordy

Climber