topic Re: How to read specific excel cells using talend in Talend Studio

How to read specific excel cells using talend

asafrian1700127126 — Fri, 20 Sep 2024 03:36:21 GMT

I have the following job and it produces as output all the excel values displayed.

How to display/get only values from specific cells? For example display only cells marked in yellow

Re: How to read specific excel cells using talend

marksouzacosta — Fri, 20 Sep 2024 14:31:08 GMT

I have used tMap for that:

Open your tMap and there you have to create two output schemas, one for each condition/column you are looking for, and set the expression filter according to your needs:

Keep the fx button enable otherwise your data will not be filtered. And in the filter expression, use idenumCat column since it is unique and easier to filter. One output you use the name column and in the other you can use namingSystem.

Will be something like this:

Regards,

Mark Costa

Re: How to read specific excel cells using talend

asafrian1700127126 — Mon, 23 Sep 2024 02:38:49 GMT

how to display only the value like "AVG INLET CO2"?
because I want to export the value to a sql table

Re: How to read specific excel cells using talend

marksouzacosta — Mon, 23 Sep 2024 13:57:56 GMT

Hi @asafrian1700127126,

Well in that case you have to use a tDBOutput component and do one of Insert/Update operations in your Database Table. The column name (in your case is the name column) should match the column name in your SQL Table.

Regards,

Mark Costa

Re: How to read specific excel cells using talend

asafrian1700127126 — Wed, 25 Sep 2024 08:14:07 GMT

i Have job below

This is the output :

How to make output2 and output3 into one line like below?