topic Re: Dynamic Content of Sheets XLS in Talend Studio

Dynamic Content of Sheets XLS

Anonymous — Fri, 14 Dec 2018 13:55:24 GMT

Hello,

I´m trying to make and Input and Output Excel, i already created a metadata containing the headers i need, but when i enter the Sheet with data, containing just a few fields they only were syncronized by Position of Columns

Like:

This Metadata:
Name | E-mail | Telephone

A | B | C

Sheet File Input:

Name | Telephone
John | 212121

Doe | 212121

And the result of tLogRow is

Name | E-mail

John | 212121
Doe | 212121

What i think its happening is the Talend only match the columns using his position

For an example:

Position A1(Metadata) to Position A1(Sheet)

Does not match by Column Name

Re: Dynamic Content of Sheets XLS

Anonymous — Fri, 14 Dec 2018 18:25:33 GMT

Well i am also new to this and need all the help regarding this. After reading your problem i found out that this would have been my case some days later.

Thanks in advance for any guide.

Regards,
Brian.

Re: Dynamic Content of Sheets XLS

dipanjan93 — Sat, 15 Dec 2018 12:02:55 GMT

Use the below logic -

Job LogicSchemas for tFileInputExcel and tFilterColumnsOutput

Re: Dynamic Content of Sheets XLS

Anonymous — Mon, 17 Dec 2018 11:29:22 GMT

Thanks for u repply

But what i want, is not exactly what u show

U are inputing a file that has all the three fields
Name, Email and Telephone

I want to input a file only contains Name and Telephone (containing the metdata with the three fields)

Best Regards

Re: Dynamic Content of Sheets XLS

Anonymous — Mon, 17 Dec 2018 11:54:49 GMT

For an example:

This is the metadatafile used for Schema

This is the input file in Excel

And the ouput using tMap should be like

Re: Dynamic Content of Sheets XLS

dipanjan93 — Mon, 17 Dec 2018 11:59:27 GMT

Could you please throw some more light about your use case?

And if that's the case why have you used Email in your metadata. You could just remove it and everything works well as per the expectation.

Re: Dynamic Content of Sheets XLS

Anonymous — Mon, 17 Dec 2018 12:06:00 GMT

Because i want to build a JOB what i can re-use them all the time.

For example: each month i receive a Excel Plan containing like 60 Columns of Data
In Month 1 i receive
Name, Telephone, Email, Function, ...
In Month 2 i can receive
Name, Email, Function, XYZ, ....
In Month 3 i can receive
Telephone, Name, Function, Email, ....

And i will have to bring a new metadata ALL THE TIME i receive the new Excel Plan
I dont want it. I want to set a singular Metadata, and automatic change the Input File of the Month using tFielList, and run the Job and extract the fields what i need. ignoring the new ones and ignoring if the position of data change along the months

Re: Dynamic Content of Sheets XLS

Anonymous — Mon, 17 Dec 2018 19:44:41 GMT

The Name and Phone fields available in every month file?

Re: Dynamic Content of Sheets XLS

Anonymous — Tue, 18 Dec 2018 10:09:39 GMT

Hello, I really dunno, can appear in every month file ou may be not. But i think it will appear in every month file, but can change the position of these fields

Re: Dynamic Content of Sheets XLS

Anonymous — Wed, 19 Dec 2018 16:04:48 GMT

Anyone?