How to match and mapping values in an excel part2

Help Studio
3

Support 1 from inputRoles is wrongly matching row 1, when doing a string Contains.

Lets rewrite to the following:

Assign activity
strRoleInRecord =

(From d in dtMapping.asEnumerable
Where d("App").toString.Trim.Equals(yourAppKeyVar)
Let rls = InputRoleVar.Trim("[]".ToCharArray).Split(","c).Select(Function (x) x.Trim).ToArray
Let wrl = d("Role in website").toString.Trim(" []".ToCharArray).Split(","c).Select(Function (x) x.Trim).ToArray
Where rls.Intersect(wrl).Any()
Select s = d("Role in Record").toString.Trim).FirstOrDefault()
1 Like