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

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

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

Thanks so much