multi schema

[Anonymous]

Hi Team,

I am new to talend. i am stuck at some thing . plz help me. problem is :

i am getting data from 3 files and all the data having different schema:

1st output: only file name filename

2nd output: data from db which contains 11 columns

3rd output: data which has 5 columns

how can i merge all the data into one file?

Thanks,

Teja

[manodwhb]

@Tejeswar2020 , do you have matching column to do lookup then you can  write it to single file using tMap.

filename should be present in 2nd and 3 rd file too then only you can join and will get the proper data.

[Anonymous]

@manodwhb  Thanks for your reply

File name is not present in other two file. there  is no common data in three output. but i have merge those 3 output.

Thanks.

[Anonymous]

sample output:

1st output : filename

2nd output: A;b;c;d;e;f

3rd output: K;l;m;n

final output i need:

    filename

    A;b;c;d;e;f

    K;l;m;n

[manodwhb · Accepted solution]

@Tejeswar2020 , Ok you can try one more thing that first read first file populate output file and second file also populate to the same output file enable the append option in tfileoutputdelimitted same in the third file like how are you passing second file and enable the append option in tfileoutputdelimiitted.

[manodwhb]

@Tejeswar2020 , if you are using enterprise edition you can do dynamic.

[Anonymous]

@manodwhb  Thank you so much