topic Re: [resolved] How to read data from a text file? in Talend Studio

[resolved] How to read data from a text file?

satyavar — Tue, 04 Nov 2014 15:06:09 GMT

Hi
I have a need to read the data from a text file in Query part of a table Input component in order to include the value from text file in Query.
Can someone please help me on how to retreive the value from text file and use it in Where clause of Query part (Not tFilterRow)
Best regards,
Kalyan

Re: [resolved] How to read data from a text file?

Anonymous — Tue, 04 Nov 2014 22:11:27 GMT

This is pretty easy to do with Talend.

One approach is to read from your file one row at a time and issue a query using the data retrieved from the file.

To do this, we read from the file with a input component and attach its row output to a "tFlowToIterate" component. This component will iterate over every row of its input, putting the values of each row in the global map for us to use later.

We then attach a database Input component with the "iterate" link from the tFlowToIterate. In the query, we use java concatenation to pushdown the value of the current iteration into the WHERE clause of the input component.

Re: [resolved] How to read data from a text file?

satyavar — Wed, 05 Nov 2014 00:00:10 GMT

I am trying to read a date field value and assign it in to where clause of query part of an input table component. I am getting an incorrect syntax error while doing this.
My query part looks something like this:
"select col1, col2, col3dtCol fom tbName where col3dtCol > " + valreadfromtxtfile

Re: [resolved] How to read data from a text file?

Anonymous — Wed, 05 Nov 2014 04:05:08 GMT

Hi,
You can set a context value for your parameter(valreadfromtxtfile)
Please see a related forum: https://community.talend.com/t5/Design-and-Development/resolved-Reading-databases-with-parameters/td-p/108926
Best regards
Sabrina

Re: [resolved] How to read data from a text file?

Anonymous — Wed, 05 Nov 2014 08:45:37 GMT

Hi kalyan,
I think this is a duplicate thread...
try following
"select col1, col2, col3dtCol fom tbName where col3dtCol > '" + valreadfromtxtfile+"'"

Vaibhav

Re: [resolved] How to read data from a text file?

satyavar — Mon, 10 Nov 2014 08:19:18 GMT

Thanks Vaibhav.