topic Re: How to apply multiple record selection conditions in Qlik Replicate in Qlik Replicate

How to apply multiple record selection conditions in Qlik Replicate

Benkku — Tue, 09 Mar 2021 12:26:45 GMT

Hi!

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.

Any hint?

Thanks,

Bernardo

***

I add here few screenshots.

Source file:

Flow:

Data transformations:

Filtering:

Target table:

Re: How to apply multiple record selection conditions in Qlik Replicate

lyka — Fri, 09 Apr 2021 22:33:04 GMT

Hello,

Performing several transformations to the same table/column/row etc. may fail, because the
transformation has already changed the metadata of the table in the task.

Have you tried to use filter conditions instead of the record selection condition?

Did you get the same results?

Thanks,

Lyka

Re: How to apply multiple record selection conditions in Qlik Replicate

john_wang — Sat, 10 Apr 2021 01:51:24 GMT

Hello @Benkku ,

Another possible reason is the spaces. Not very sure what's the source table column definition. you may adding trim() function in your expression, or simply by adding the trailing spaces, like:

($Parcel_ID != "Parcel_ID") AND ($Category != "IMPORT ")

Hope it helps.

John.