Flatting data in talend studio

[Bharath12]

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, 

[akumar2301]

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

[Bharath12]

Hi Abhishek,

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

Thanks,

[akumar2301]

Hello 

Can you show your job ?

Below is my result:

Please check if you did it correct

[Bharath12]

Hi Abhishek,

Please find the below screenshot.

[akumar2301]

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

What is output of your job?