topic Re: Flatting data in talend studio in Talend Studio

Flatting data in talend studio

Bharath12 — Sat, 16 Nov 2024 06:42:20 GMT

Hi,

i have issues with flattening data in talend studio 6.3. I am new to the talend can some one help me how to do that.

Source data:

i have the data with two columns:

GID MID

g123456 123456

g123456 g456789

g456789 123567

g456789 123789

i need output like below

GID MID

g123456 123456

g123456 123567

g123456 123789

g456789 123567

g456789 123789

can some one help me how to do flatting using talend 6.3.

Thanks,

Re: Flatting data in talend studio

akumar2301 — Thu, 31 Jan 2019 20:12:21 GMT

Try tmap with main and lookup as your file.

Outerjoin ( main mid = lookup gid)
All match

If match found out main gid and lookup mid
If match not found main gid and main mid

something like this

Re: Flatting data in talend studio

Bharath12 — Fri, 01 Feb 2019 20:38:10 GMT

Hi Abhishek,

Thank you. it didn't work. Still i am getting the same data.

Thanks,

Re: Flatting data in talend studio

akumar2301 — Fri, 01 Feb 2019 21:08:08 GMT

Hello

Can you show your job ?

Below is my result:

Please check if you did it correct

Re: Flatting data in talend studio

Bharath12 — Fri, 01 Feb 2019 21:17:29 GMT

Hi Abhishek,

Please find the below screenshot.

Re: Flatting data in talend studio

akumar2301 — Fri, 01 Feb 2019 21:30:03 GMT

Are your columns data are well trimmed ? it might have some space.

What is output of your job?