Join dt

Help
, ,
1

Hello all,

I am trying to join two datatables using (INNER) based on 2 conditions. On DT1 the cells are written in capital letters while on DT2 they aren’t. Could this cause issues?

Example:
DT1
SMITH
LOREN

DT2
Smith
Loren

When I run the bot, it gives me a null values for the JOINED DT when there should be 13 common rows between the two.

Any thoughts on this?

Thank you

2

@rjackson
Yes, WE assume that the different Forms will prevent the Match. Give a try on following

(From d1 in dt1.asenumerable
Join d2 in dt2.asenunerable
On d1(0).toString.trim.toupper Equals d2(0).toString.trim.toupper
Select d1).ToList

This linq will Return the Matching rows from dt1 as a list of datarows and you can postprocess this result e.g copying to a datatable