topic Re: multi schema in Talend Studio

multi schema

Anonymous — Fri, 29 May 2020 08:53:46 GMT

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

Re: multi schema

manodwhb — Fri, 29 May 2020 09:07:49 GMT

@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.

Re: multi schema

Anonymous — Fri, 29 May 2020 10:43:05 GMT

@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.

Re: multi schema

Anonymous — Fri, 29 May 2020 10:53:44 GMT

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

Re: multi schema

manodwhb — Fri, 29 May 2020 10:59:20 GMT

@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.

Re: multi schema

manodwhb — Fri, 29 May 2020 11:25:04 GMT

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

Re: multi schema

Anonymous — Fri, 29 May 2020 14:24:36 GMT

@manodwhb Thank you so much