topic Import list value context variable in Talend Studio

Import list value context variable

chichibio — Sat, 16 Nov 2024 08:42:28 GMT

Hi,

I need import the value to insert in oracle query. So...

I have file (csv or txt is the same). I need read value x,y,z.. After I store that value and use that

in oracle query like this: select * form table where value in ('x','y','z').

How to do that?

thnx at all

best regards

Re: Import list value context variable

TRF — Tue, 13 Feb 2018 10:55:59 GMT

Hi,
If x,y,z are issued from different records, use a tJavaRow to construct the "in" clause into à global variable. Then reuse it in your tOracleInpout to complete the query.

Re: Import list value context variable

chichibio — Tue, 13 Feb 2018 11:13:46 GMT

mmm... I have the problem to do the first step.

How I can read and store the list of value inside the file?

After I can use tJavaRow?

The example of open file is like this: name = test.csv

without comma or other separator

Re: Import list value context variable

TRF — Tue, 13 Feb 2018 11:23:39 GMT

Connect tJavaRow after tFileInputDelimited.
You will have each row one by one so it's easy to concatenate values an build the desired part of the query with something like:
context.yourVariable = context.yourVariable + ", '" + input_row. yourField + "'" ;
You'll have to finish the construction from outside of the tJavaRow to remove the 1rst character.

Re: Import list value context variable

chichibio — Tue, 13 Feb 2018 13:59:12 GMT

Thnx!

Your suggest work. But I have 1 one problem. I change the file contains and I don't concatenate to have "'" or ",".

So, my file I have the follow text:

'a',

'b',

'c'

But after the query,in tLOGrow the output is just only 1 record and not 3 records.

I show you my print screen

In my oracle query I have: select * from table where idcase IN ("+context.variable+")

Re: Import list value context variable

TRF — Tue, 13 Feb 2018 14:17:01 GMT

What if you execute the same query from outside of Talend (using SQL*Plus)?

Re: Import list value context variable

chichibio — Tue, 13 Feb 2018 14:33:14 GMT

If I execute the same query in tOracle component without context variable, It works.

Re: Import list value context variable

TRF — Tue, 13 Feb 2018 14:38:33 GMT

1rst, you have put 3 line in the input file but it seems (based on the capture), only 2 are read.

Can you print the context variable after the construction (add a System.out.println inthe tJavaRow)?

Re: Import list value context variable

chichibio — Tue, 13 Feb 2018 14:49:13 GMT

Sorry, I wrong the example. You right.

So... input file I have 3 records and in tJavaRow I wrote this: context.elenco = row1.val_id;
System.out.println(context.elenco);

Re: Import list value context variable

TRF — Tue, 13 Feb 2018 14:52:26 GMT

You need to change the tJavaRow like this:

context.elenco = context.elenco + row1.val_id;

Else you will query only for the value 'c'.

Right?

Re: Import list value context variable

chichibio — Tue, 13 Feb 2018 14:59:39 GMT

It works well now.

Thnx so much TRF.

You are the boss of Talend

very good

thnx

Re: Import list value context variable

TRF — Tue, 13 Feb 2018 15:00:33 GMT

You're welcome!