here num(Kostenstelle) <>'1011747' and num(Kostenart) <> '2581500000' and num([Konto Gegenbuchung]) <> '10010';
But this string tells the scrip not to load lines that match all 3 kriteria, If u what to string not load lines that have one of the kriteria u should use OR instead or AND.
you are using an 'and' condition for your three criteria, is that how the data is represented?
Should the row you want to delete meet all three of the requirements, or are you actually wanting to delete any rows which meet have any of those criteria?
Your code at the moment looks fine if the row should contain all three.
If not and each should be separate, then an 'or' condition should be used.
Where Not (Kostenstelle ='1011747' Or Kostenart ='2581500000' or[Konto Gegenbuchung]= '10010')
Use Not match() or Not wildmatch() in where clause
try like
Where not Wildmatch(Kostenstelle,'*1011747*','*2581500000*') or not wildmatch([Konto Gegenbuchung],'*10010*')
use or/And as per requirement in abve expression
Regards
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Great dreamer's dreams never fulfilled, they are always transcended. Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
