How to apply multiple record selection conditions in Qlik Replicate
I am familiarizing with Qlik Replicate data transformation capabilities and I am trying to apply multiple conditions to filter out rows in a table.
The first condition is needed to drop the headers containing the filed names, so I have inserted the condition that the first column does not contain its name as a value:
$Parcel_ID != "Parcel_ID"
The second condition filter out all the rows that contain the value IMPORT in the column Category.
This is the full expression:
($Parcel_ID != "Parcel_ID") AND ($Category != "IMPORT")
I tested the expression and it works.
However, the result is that the first condition works and the field headers are not visible in the result but the second condition does not work and also the fields that have value IMPORT in the Category column are copied into the destination table.