Loading target based on condition

DM2017 — Thu, 11 Jan 2018 12:32:54 GMT

Hi Team,

I have a table(target) which has 5 rows , one of the column name:slno have values (12,13,14,34,56), I need to load data from my source table to target based on the max value of target. example

if in the source table for slno column values are (12,13,14,34,56,88,89,90,99) then only (88,89,90,99) values should go to target (along with all rows), basically I need to find max from target and based on that I need to load rows after that value.

Not able to figure out how to do, I heard of using tsetglobalvar, but no luck.

please help.

Re: Loading target based on condition

billimmer — Thu, 11 Jan 2018 14:27:07 GMT

Have you tried tfilterrow? You can also do this with t(YourDB)Input and write your own select query. You can also set a filter in tMap.

topic Loading target based on condition in Talend Studio

Loading target based on condition

Re: Loading target based on condition