select a table row value where equals to rows from file text .

Seventeen Stars

select a table row value where equals to rows from file text .

hi,
I've got a delimited file with several rows and values (a normal one so), wherein for each value from the column "untel" I've got a "correspondante " value store in a As400 table
I've tried to use TfileDelimited => tAS400Row with a query : "SELECT FDEVIS.DEVNOLM FROM FDEVIS where row2.column0 = FDEVIS.NOPROSP" => and tFileOutputDelimited (or another table ... never mind)
but doesn't work !
I've red help content help but nothing with a value in entry ...
In "summary"(lol) :: read a (foreach) value => looks for equivalence in a table (select)=> write result !
Looks simple but need your help
by advance thanks a lot
Seventeen Stars

Re: select a table row value where equals to rows from file text .

... give you more "details" on my needs.
Is it enought explicit !?
Which Component to use in this case !?
Seventeen Stars

Re: select a table row value where equals to rows from file text .

Actually the only thing i got it's an iteration on the syntaxe Sql (System.out.println(((String)globalMap.get("tAS400Row_1_QUERY")))
with a request in AS400Row :
"SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE "+row1.NOPROSP+"=FDEVIS.NOPROSP"

for a result :
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000482391=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000440281=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000460825=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000431051=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000509042=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000431051=FDEVIS.NOPROSP
SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000504413=FDEVIS.NOPROSP
... etc

from an input file
NOPROSP
0000000482391
0000000440281
0000000460825
0000000431051
0000000509042
0000000431051
0000000504413
...etc

... but of course i need THE RESULT of "SELECT FDEVIS.DEVNOLM FROM FDEVIS WHERE 0000000482391=FDEVIS.NOPROSP" ...etc not the syntax (lol)
... any help !??
thanks
Seventeen Stars

Re: select a table row value where equals to rows from file text .

if I read "help Content" for tmysqlrow :
Le suffixe Row signifie que le composant met en place un flux dans le job bien que
ce composant ne produise pas de données en sortie.

... seems meaning " no output data for a txxxRow" !!
How can I catch those data so !? no with a tAS400Row !?
Seventeen Stars

Re: select a table row value where equals to rows from file text .

any idea or some informations ...!?
I've tried with filter Row but no sure it's the good one .
I'm just a little "lost" ...
++
laurent
Highlighted
Employee

Re: select a table row value where equals to rows from file text .

If you really don't want to use a tMap, you can do
tFileInputDelimited -> tAs400Row -> tParseRecordSet -> ....
Add a new object column in tAS400Row schema.
Define it in tAS400Row -> Advanced Settings -> Propagate QUERY RecordSet option.
and in tParseRecordSet to parse the results from tAS400Row "select" request.
HTH,
Seventeen Stars

Re: select a table row value where equals to rows from file text .

hi mhirt,
It it's possible with tMap .... I take it!
I've tried with your solution but always 's got some errors ...(a "red" alert like on your screenshoot).
So i've tried with tMap : get 2 entries (as400 input and tfileinput z value) => tMap ....
But now how to put my condition !? (select mytable.X from mytable Where mytable.y = z)
I've got all value to do my job but don't find the right way !!(sic)
My problem is to include the variable Z in the query !
With tparseRecord set, it propagate the result (if i 've unterstood the goal of this component) !
but a tmap solution can be the good one ...
EDIT : tparse error => (*** ERROR in Table ***); due to a bad request i guess because didn't recognize th value in my select query (!!?)
the entire java generated code error :
row3.NOPROSP = re_tParseRecordSet_1.getObject(*** ERROR in Table ***);
Employee

Re: select a table row value where equals to rows from file text .

You didn't configure properly the tParseRecordSet "Attribute table".
Verify it according to my last screenshot.
Seventeen Stars

Re: select a table row value where equals to rows from file text .

hi, mhirt,
Ok , now it's work fine !
You let me expexted that it could work with a tMap component as well !
Can you give me the way to do it with it ....(not entire solution, but the "suite of" component) .
I still have some "problems" with the passed value throws different component .
anyway, thanks a lot for your help
laurent

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download