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
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.