topic Re: Output filter column with append existing excel file in Talend Studio

Output filter column with append existing excel file

Anonymous — Fri, 14 Jun 2019 14:46:35 GMT

Hi,

I will write an example to explain my request.

I have a file named "file-A" with for example column B - E - G ; and a "file-B" to fill, acutally it has only his header with column A B C D E F G H.

So I created a metadata for my file-A and my file-B.

How can I fill my file, using I suppose "attend existing file" and only the column B E G will be fill, others will stay empty, and using my metadata because actually in my real file-B I have like 200 column and I don't want to create them one by one in a tMap...

Is there any component or way to say : Column A from file-A go to column B from file-B, same with E and G, and the others are empty.

Hope you'll understand, thanks

Re: Output filter column with append existing excel file

Anonymous — Fri, 14 Jun 2019 14:55:58 GMT

I'm not very sure, but I think you have simulate the structure of file-B in file-A

(read file-A) --->tMap-->(you add empty column to make the output similar to file-B structure)--------->(then you apend the content in file-B)

Re: Output filter column with append existing excel file

Anonymous — Fri, 14 Jun 2019 15:09:26 GMT

Yes I have this solution in my mind but, like what I said, I have like 200 column in my real file-B structure, and I don't want to create all columns one by one in tMap when my metadata is ready... But if there is no other solution, I'll do it with tMap

Re: Output filter column with append existing excel file

navds — Fri, 14 Jun 2019 15:42:41 GMT

You can use tSetDynamicSchema. Not sure if it is available for the Open Studio though.

Re: Output filter column with append existing excel file

Anonymous — Fri, 14 Jun 2019 15:45:30 GMT

It is not I guess because I can't find it