Qlik Community

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Benkku
Partner
Partner

How to apply multiple record selection conditions in Qlik Replicate

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:

source_file.png

Flow:

flow.png

Data transformations:

7_data_transformations_1.png

8_data_transformations_2.png

10_field_value_changes.png

Filtering:

9_filtering.png

Target table:

13_target_DB.png

Labels (1)
2 Replies
lyka
Support
Support

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

john_wang
Employee
Employee

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.