Separate Row in Two Diferent

Highlighted
Four Stars

Separate Row in Two Diferent

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:

id tipo Obs out
1 a ok id1 tipoa
2 b ok id2 tipob
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.

Highlighted
Nine Stars

Re: Separate Row in Two Diferent

Hi @santanavalee,

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.

Thanks,

Ankit.

Highlighted
Four Stars

Re: Separate Row in Two Diferent

hi @ankit7359,

IDTYPECOMENT
1A 
2B 
3CIF TYPE="C" THEN I NEED TO CREATE A NEW ROW.VALUE="X" AND NEW ROW.VALUE="Y"
4A 
5A 

 

i have 3 type of values and when i have the value "c" i need to separate in 2 diferent row.

Highlighted
Seven Stars

Re: Separate Row in Two Diferent

Hi santanavalee,

 

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.

 

Best regards,

 

Thomas

 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog