I have tried this Query Syntax is (From row In dt.AsEnumerable Join row1 In dt1.AsEnumerable On row1("DeptID").ToString Equals row("DeptID").ToString Select outDT.Clone().LoadDataRow({row("ID").ToString, row("Name").ToString, row("DeptID").ToString,row("Salary").ToString, row1("DeptName")}, False)).CopyToDataTable()
Very helpful video. I have a question whether the Join applied in this scenario is a 'Left Join'?
thanks a lot for this , is there a simpler way to pass the new colums into the data table other than creating a new object?
Completed, thank you! :)
Very nice video. Could you please make a video on Document Understanding using Rest API?
Completed.
Done
Not working, I am getting source contains no datarows, cross checked query multiple times.
I have tried this Query Syntax is (From row In dt.AsEnumerable
Join row1 In dt1.AsEnumerable
On row1("DeptID").ToString Equals row("DeptID").ToString
Select outDT.Clone().LoadDataRow({row("ID").ToString, row("Name").ToString, row("DeptID").ToString,row("Salary").ToString, row1("DeptName")}, False)).CopyToDataTable()