Tmap (innerjoin) returns 0 rows

[INESBK]

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.

[Anonymous · Accepted solution]

Hi

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

[INESBK]

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.

[Informatique1]

Have you tried Left Outer Join for exemple?

[Anonymous]

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?