Hi, im new using Talend and i need a component or something who help me to separate row in two, so, i was searching and i find the component tPigFilterRow but it doesn't available in the version 6.4.
My question is, exist a alternative to this component in the version that i use?
An example to that i need to do:
|3||ab||need to separate in two row||id3 tipo a|
|id3 tipo b|
in case of id 3 was separate in two row, so that is what i need.
Can you pls give another example of your scenario and can you pls explain your challenges in brief.
Pls do get back to Community,if necessary.
|3||C||IF TYPE="C" THEN I NEED TO CREATE A NEW ROW.VALUE="X" AND NEW ROW.VALUE="Y"|
i have 3 type of values and when i have the value "c" i need to separate in 2 diferent row.
I attached two screenshots of tMap components. The code is rather simple because I do not know e.g. if "tipo" contains only "a", "b" or "ab" or more complex strings. Also these tMaps produce two outputs instead of creating new rows in just one output.
If your data volume permits, you can write these tMap outputs into two tHashOutput components. Then use two tHashInput components to read the data and connect them both as inputs to a tUnite component.
I hope you can use or build on my suggestion.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema