Inner Join does not do as expected

Help
1

Hi friends,

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

All Entries DT Collected Filtered:
image

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

image

What am I doing wrong?

Thanks,
Robert

2

@BOTFORCE
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
3

Hi Robot Master,

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

4

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)

Regards
Peter

5

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)

thx.
Robert

6

GetInnerJoinData.zip (33.0 KB)

Hi,
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

7

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

8

@BOTFORCE
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)

2 Likes
9

Thanks all of you for your effort!
BR. Robert

10

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