Separate Row in Two Diferent

[Anonymous]

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.

[ankit7359]

Hi @alee,

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.

[Anonymous]

hi @ankit7359,

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

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

[ThWabi]

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

typeC_tmap.jpg
tipo_tmap.jpg