topic Re: Different Sheets in Input in Talend Studio

Different Sheets in Input

Anonymous — Wed, 03 Jul 2019 17:41:40 GMT

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

Re: Different Sheets in Input

Anonymous — Thu, 04 Jul 2019 02:00:16 GMT

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 🙂

Re: Different Sheets in Input

Anonymous — Thu, 04 Jul 2019 13:15:20 GMT

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

Re: Different Sheets in Input

Anonymous — Thu, 04 Jul 2019 14:09:08 GMT

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 🙂

Re: Different Sheets in Input

Anonymous — Thu, 04 Jul 2019 14:58:28 GMT

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.

Re: Different Sheets in Input

Anonymous — Thu, 04 Jul 2019 15:05:24 GMT

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 🙂

Re: Different Sheets in Input

Anonymous — Thu, 04 Jul 2019 15:07:15 GMT

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