Hi All ,
I have a Table of 6 records , I need to make 2 targets and first 3 rows will go into target 1 and last 3 rows will move into target 2 .
I dont want it in even/ odd format with "%2" operation. .
Thanks in advance .
Greetings of the day,
Well your scenario can be acheived in Tmap by using sequence number function and for this -
i) add a column by name id or something to uniquely define your column and then write a function in the expression builder Numeric.sequence("s1",1,1) and then you can apply filter for spliting the records.
ii)you can try using another component to explore - tsamplerow.
If you are still facing issues,Pls reach out to the Community.
@subhadeep to complete my first posts, here is what your tMap should look like:
Then if you push these flows to 2 tLogRow components, here is the result:
[statistics] connecting to socket on port 3799 [statistics] connected .----. |tLogRow_2| |=--=| |Col1| |=--=| |1 | |2 | |3 | '----' .----. |tLogRow_3| |=--=| |Col1| |=--=| |4 | |5 | |6 | '----' [statistics] disconnected
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Learn how and why companies are moving to the Cloud