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;
Join us live for a sneak peek!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.