topic Separate Row in Two Diferent in Talend Studio

Separate Row in Two Diferent

Anonymous — Tue, 08 Jan 2019 14:20:01 GMT

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.

Re: Separate Row in Two Diferent

ankit7359 — Wed, 09 Jan 2019 11:28:04 GMT

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.

Re: Separate Row in Two Diferent

Anonymous — Wed, 09 Jan 2019 11:43:30 GMT

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.

Re: Separate Row in Two Diferent

ThWabi — Tue, 15 Jan 2019 14:40:47 GMT

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