Separate Row in Two Diferent

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.

Eight 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.

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.

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

 

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download