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?
Thanks,
Robert
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?
Thanks,
Robert
@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
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)
Regards
Peter
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
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
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:
strong text
@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)
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.