topic Re: Tmap (innerjoin) returns 0 rows in Talend Studio

Tmap (innerjoin) returns 0 rows

INESBK — Fri, 15 Nov 2024 22:00:14 GMT

Hello,

I have two data sources: an EXCEL file named and a table named in MS SQL Server database.

I would like to update a table from the information in the Excel file. I started by displaying the results on the console before modifying the table. However, I still get 0 results from the inner join.

I tried to display the table and file results and it works. It seems that there is no correspondence between the 2 sources which is not true.

Below are screenshots of my job.

Thank you in advance for your help.

Re: Tmap (innerjoin) returns 0 rows

Anonymous — Sun, 12 Mar 2023 23:57:53 GMT

I don't see any issue on the job design, you just need to check the data in both data source, and confirm there exists the same value in ID_PCVUE field from Excel and NAME filed from MS SQL Server table, maybe you need to trim the column.

Regards

Shong

Re: Tmap (innerjoin) returns 0 rows

INESBK — Tue, 14 Mar 2023 17:21:10 GMT

Hello,

Thank you for your response.

The same values in Name and ID PCVUE exist well and also I trimmed these 2 columns. But I still get 0 rows in output.

Re: Tmap (innerjoin) returns 0 rows

Informatique1 — Wed, 15 Mar 2023 10:43:42 GMT

Have you tried Left Outer Join for exemple?

Re: Tmap (innerjoin) returns 0 rows

Anonymous — Wed, 15 Mar 2023 23:38:30 GMT

The job design is OK, I need take a look at your data, is it possible to provide me some example data for investigation and testing?