topic Re: Filter condition in full load pass thru in qlik replicate in Qlik Replicate

Filter condition in full load pass thru in qlik replicate

chandraprakash_j_volvo — Fri, 08 Dec 2023 10:34:17 GMT

I want to limit the number of records during full load.

So in full load pass thru I am using filter condition for "ID" column.

But it gives error with ORA-00908: missing NULL keyword

What mistake i am doing here?

Re: Filter condition in full load pass thru in qlik replicate

chandraprakash_j_volvo — Fri, 08 Dec 2023 10:42:10 GMT

Even I have tried with

$ID = 'abc'. it gave ORA-00911: invalid character as an error

Re: Filter condition in full load pass thru in qlik replicate

john_wang — Fri, 08 Dec 2023 11:04:35 GMT

Hello @chandraprakash_j_volvo ,

Thanks for reaching out to Qlik Community!

Would you try the express: ID = 'abc' in "Fullload Passthrough Filter"?

If you still face any error, please turn on SOURCE_UNLOAD to Verbose and check the SQL Statements in task log file to understand why the expression failed.

Hope this helps.

Regards,

John.