Talend community forum / synchronize 2 input data throws result tParseRecord

kzone · 2008-12-15 16:47:19

Tags: [delimited file, java, tAS400Row, tos3.0.0, tParseRecordSet]

hi,

I have a input file delimited in entry with some column (14) ; I've to "extract" value from the thirth column ; select a value in a table where tableValue = column3.value ; get the result and write all result in another table ( .... )

right a little screenshoot.and more explanation :

make : select with tRow :

"select distinct devnolm from jmvbib.fdevis inner join jmvbib.facadh on facnopros1=" + row1.PDPADH + " and facnopros1=noprosp and devnolm>0"

and propagate result with tParseRecord Set ; after that map the throws Tmap to table As400 output

and got exception :

Code:

Exception in component tParseRecordSet_1
java.sql.SQLException: An undefined column name was detected.
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:389)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:366)
      .......

work fine when I just match the resultset (without "propagate other value")

I have also try with 2 entry for the same file : one to match te resultset value and one for the 13 other column' values.
But the 2 entries don't work on the same time .

Normally I 've to have the solution for tonight ..so
If anyone could help me ... thanks a lot

laurent

Uploaded Images

Last edited by kzone (2008-12-15 16:58:08)

kzone · 2008-12-15 17:22:13

other way I've try to "synchronize" entry twice from the same tinputFile

And what means "lookup" in this case !??

thanks

Uploaded Images

Last edited by kzone (2008-12-15 17:25:35)

kzone · 2008-12-16 15:13:11

If I had red documentation more carefully ....

in fact it was "so" simple : with a request in the As400 input

Code:

"select distinct int(NOPROSP) as noprosp,
max(DEVNOLM) as DEVNOLM from fdevis inner join facadh on fdevis.noprosp=facadh.facnopros1 
group by INT(NOPROSP)"

and a "outer join" in the tMap shema

I was realy in the wrong way ...

Uploaded Images

Last edited by kzone (2008-12-16 15:14:19)

Announcement

Unanswered posts

#1 2008-12-15 16:47:19

synchronize 2 input data throws result tParseRecord

Code:

#2 2008-12-15 17:22:13

Re: synchronize 2 input data throws result tParseRecord

#3 2008-12-16 15:13:11

Re: synchronize 2 input data throws result tParseRecord

Code:

Board footer