Qlik Sense exclude values before load data

[ZigaD]

hi guys

you think some can help me with how i can exclude data from specific excel column, before is loaded?

for example from Column "a" i would like to prevent loading rows which include values "n1", "n2", "n3" etc.

appricate you help

[TimvB]

To filter data from a source (e.g. Excel), you should use a where clause. For example:

TableName:

Load 

*
From YourExcelSource

Where not match([a], 'n1', 'n2', 'n3');

Hope it helps!

[ZigaD]

Hi

thank you for your reply its still loading so i tried below one, but it think it works only one, not multi parameters

WHERE a<>'n1'

and it created me a total new data source with "TableName_1"

can i avoid this or its normal process?

[TimvB · Accepted solution]

WHERE a<>'n1' is indeed a valid script. If you have multiple parameters, you could use the Where Not Match() approach. 

Every time you extract a table by using the statements From or Resident, a new table is created. You can then drop the table that you do not need anymore.

[Kashyap_R · Accepted solution]

Hi

try this

Table:

Load 

*
From Source

Where [a]=if(WildMatch(Trim([a]), 'n1', 'n2', 'n3')=0,[a]);

Hope this helps

Thanks

[ZigaD]

Hi Kashyap,

thank you for your help, it worked.

Appreciate your help