How to read specific excel cells using talend

[asafrian1700127126]

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

[marksouzacosta]

Hi @asafrian1700127126 ,

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

[asafrian1700127126]

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

[marksouzacosta]

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

[asafrian1700127126]

i Have job below

This is the output :

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