We are trying to create a task in which one table is present and from that table we are trying to extract 1 result through expression builder.
We tested the SQL syntax as our source DB is Oracle and it's successfully passing the test expression but still instead of getting Transferred count as 1, it's giving the count as 31,362,906.
Don't know whether we are using the correct syntax or not but not getting the desired result.
We are feeding the syntax Table Settings>>Filter>>Expression Builder.
"Filter Conditions" and "Record Selection Condition" (Expression Builder) function differently in the process. For example, if you define ID=1 in the "Filter Conditions," Qlik Replicate will send a query to the source database like this:
SELECT ID, col1, col2 FROM table WHERE ID=1
In contrast, if you define it in the Expression Builder, Qlik Replicate will send the statement:
SELECT ID, col1, col2 FROM table
The filtering will then occur on Qlik Replicate internally, which is why you observe a count of 31,362,906.
You can verify the record count in the task log, which indicates how many records were received and skipped. For example:
[TARGET_LOAD] I: Load finished for table 'dbo'.'test01' (Id = 1). 4 rows received. 0 rows skipped. Volume transferred 1584.
Regards, Desmond
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
In addition, we just want to do full load with this condition mask column names but instead of Transferred count as 1, it's giving the count as 31,362,906.
"Filter Conditions" and "Record Selection Condition" (Expression Builder) function differently in the process. For example, if you define ID=1 in the "Filter Conditions," Qlik Replicate will send a query to the source database like this:
SELECT ID, col1, col2 FROM table WHERE ID=1
In contrast, if you define it in the Expression Builder, Qlik Replicate will send the statement:
SELECT ID, col1, col2 FROM table
The filtering will then occur on Qlik Replicate internally, which is why you observe a count of 31,362,906.
You can verify the record count in the task log, which indicates how many records were received and skipped. For example:
[TARGET_LOAD] I: Load finished for table 'dbo'.'test01' (Id = 1). 4 rows received. 0 rows skipped. Volume transferred 1584.
Regards, Desmond
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
