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
Solved! Go to Solution.
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
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:
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+")
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)?
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;
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Find out how to migrate from one database to another using the Dynamic schema
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences