Unable to fetch delta batch using tSAPTableinput component

KarthikGs — Wed, 15 Feb 2023 12:00:12 GMT

Hi Team,

I'm trying to fetch new batch of data using filter condition in tSAPTableinput component by using the filter option ( attached in the screenshot).

The source column DAT is of format (yyyy.MM.dd) and the context variable is also of same column.

I am using 2023.02.13(context.last_loaded) as the delta value. While running the job the filter is picking up wrong set of records which contain data of Jan month as well.

Scenario 1 : when i'm using context variable as string, it fetching more data than expected.

Scenario 2: when i'm using context variable as date, no data is being fetched.

Can someone, throw light on where am i doing it wrong?

Re: Unable to fetch delta batch using tSAPTableinput component

Anonymous — Fri, 17 Feb 2023 05:28:06 GMT

Hello,

Note that the column value must be surrounded by single quotes and there must be a blank space before and after the equals sign (=) in the filter expression.

Here is the component reference about:

https://help.talend.com/r/en-US/8.0/sap/tsaptableinput-standard-properties

And please try to use yyyyMMdd date format without any "." and could you please post your context variable setting screenshot here?

Best regards

Sabrina

topic Unable to fetch delta batch using tSAPTableinput component in Talend Studio

Unable to fetch delta batch using tSAPTableinput component

Re: Unable to fetch delta batch using tSAPTableinput component