Talend community forum / Join between a table and a delimited file

dhonore · 2009-06-23 13:49:47

Help!!!!
I become crazy.

I want to join a table (DB2/400) and a delimited file.

I have checked that I can find one value of my table in the values of my delimited file.
So I should have at least one row in the destination file.

When I uncheck the inner joint checkbox, I have all the records of my table
When I check the inner joint checkbox, I don't have any records.

But in cases, I don't have the expected data.

Any suggestions to debug this issue???

Thanks

Didier

Uploaded Images

dhonore · 2009-06-23 13:51:38

The screenshots

Uploaded Images

dhonore · 2009-06-23 13:53:44

the screenshots

Uploaded Images

smalleret · 2009-06-23 15:08:14

Hello Didier,

Maybe your key on AS400 is a CHAR type with blank after your data? Can you try with "Trim all the String/Char columns" checked in the Advance Settings tab on tAS400Input?

dhonore · 2009-06-23 15:51:28

You are the winner!

I have looked for blank in the excel file not in the table.

Thanks for your help

Didier

Announcement

Unanswered posts

#1 2009-06-23 13:49:47

Join between a table and a delimited file

#2 2009-06-23 13:51:38

Re: Join between a table and a delimited file

#3 2009-06-23 13:53:44

Re: Join between a table and a delimited file

#4 2009-06-23 15:08:14

Re: Join between a table and a delimited file

#5 2009-06-23 15:51:28

Re: Join between a table and a delimited file

Board footer