Inner Join does not do as expected

Hi friends,

I have two data tables:
1 - collectedFilteredDT
2 - allEntriesIDDT

All Entries DT Collected Filtered:

When I perform an inner join, I become 0 rows in the joinEntIDDT:


What am I doing wrong?


if the values come from excel check if there spaces after the values as this confuses the activity

as an lternate you can go with an assign and a LINQ

(From d1 In dt1.AsEnumerable
Join d2 In dt2.AsEnumerable
On d1(0).toString.Trim Equals d2(0).toString.Trim
let ra = new Object(){d(0)} // Do fetching col values as you need
Select ra).toList

the returned list of Object() can be used for a add row to the result datatable. Adding the rows to the result datatable can also be integrated into the LINQ

1 Like

Hi Robot Master,

yes the values come from excel, but there are no spaces before or after any value.

ok, strange thing but can occur. But van you give a try on the LINQ? Also feel free to share some sample data with us.

for starter help have a look here:
DataTable_Join_1Col.xaml (10.3 KB)


here you go with the data…I deleted the other columns as these are irrelevant:

DQResultListe.xlsx (11.9 KB) CollectedDataPhoenix.xls (3.1 KB)

Robert (33.0 KB)

Please check the attached sample flow with your inputs. ‘CollectedDataPhoenix.xls’ fie is not worked for testing I just copy the data created new.

Please provide feedback. Mark as solution if it works

Hi Venugopal24,

thx, this works. One more thing on top and maybe you can add you advise to it.

What Do I need to change to get only the Entry_ID’s which are in DTcollectedData but not in DTdqResult. It’s like an left inner join:
image strong text

find a demo on matching / non matchings with Join Activity
Get_MatchingNonMatching_JoinActivity.xaml (13.7 KB)

find a demo left Join with Linq
LINQ_LeftOuterJoin.xaml (9.7 KB)


Thanks all of you for your effort!
BR. Robert

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.