How to use left join LINQ in the UIPATH table A/B/C

Learn Academy Feedback
, ,
1

hello experts, is there anyone who knows how to use left join LINQ for the table A/B/C
the condition is that the “Invoice” in the A/B/C is the same that will be Y. otherwise is N

Datatable A
invoice Code
123 1
234 2
345 3
Datatable B
invoice code
123 1
234 2
Datatable C
invoice code
123 1
the result will be like this
Datatable D
invoice code resultAB resultAC
123 1 Y Y
234 2 Y N
345 3 N N
2

@Yin_Wang
Have a Look Here to find an Initial Starter Help on linq Syntax with Group Join and defaultifempty usage

How to left join two tables using Linq Query with all data in left table? Please Help

1 Like
3

Thanks so much