Find similar id from dt1 to dt2 if not found to dt2 check dt3

[ldiaz (Leonardo Diaz)]

how can apply this in linq(assign activity)

If(IsNothing (MSMEDT.AsEnumerable.Where(Function (x) x(3).ToString.Equals(currentrow(7).ToString)).FirstOrDefault()),currentrow(19).ToString,“MSME”)

this works in two dt. but i want to add the dt3 to find similar id if the if from dt1 is not found in the dt2

[supermanPunch (Arpan)]

@ldiaz

i want to add the dt3 to find similar id if the if from dt1 is not found in the dt2

Hi @ldiaz ,

We do not get what is the actual requirement here ?

Could you maybe explain to us in a bit more detail ?

You could opt also for the normal If Condition Activity and check whether you’re logic applies using that method, then if needed we can transform to the inline If.