Different Sheets in Input

[Anonymous]

Hello,

Im working on a input file XLSX that contains 3 Sheets with this stuff

Name	Age	Work
Joao	22	IT
Pedro	43	Medical

Name	Married
Joana	Y
Vanesa	N

Name	Car	State	Street	Surname
Alex	Ferrari	A	C	Alex
John	Corolla	B	D	Jow

To read all data i need 3 Metadata differents? or i can make a dynamic metadata to read these data?

Because if needed 3 metadata i have to insert 3 tFileInput with different metadata, and thats embarasing

[Anonymous · Accepted solution]

Hi,

  In your case, its better to use 3 separate schemas to parse each sheet. You can use dynamic schema also but below are the limitations for it.

• The dynamic column must be mapped on a one to one basis and cannot undergo any transformations.

• The dynamic column cannot be used in filter expressions or in variables.

• The dynamic column cannot be renamed in output tables and cannot be used as a join condition.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Thanks, the use of 3 separated schemas is better to my issue, but will became a very embarassing job. but is the only way

[Anonymous]

Hi,

   There is nothing to be embarrassed about it 🙂  For simple tasks, we need simple solutions. I don't think the need of dynamic schema is present in this use case.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Yes will be, its harder to explain my Currently Job.

For u take a look better all these sheets was examples of data.
Because my data i think its protected, and i cant spread this out.
On my Input file i have like 8 Sheets containing differents schemas, and in the end all of them match to one output.

The Output must be Name, Code, Attributes and IMG URL,
So if in Sheet one i have 3 Attributes (Color, Size, Age)
In Sheet two i can have (Color, Weight)
In Sheet three i can have (Weight, Size, Used for)

Remember the columns are example, each sheet has like 15-30 attributes 

Finally will have the Name of each product of every sheet shown in this way (Name, SKU, Attributes). And in attributes will merge these datas(Weight, Size, Age, Color, Used for) Which contains will have this attribute, whose not will be empty.

[Anonymous]

Hi,

    This proves that you need to read sheet at column level quickly through various lookups and joins. So I would definitely go by normal approach of reading them as separate sheets and process them quickly.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Yes, i know that. I was wondering if has a simple way without doing a insane job with 30 components
HAHAHHA

Thanks again for yor support