Join DataTable without Condition

I have two datatables, i need to join the datatables without using the condition, How to join those datatable

Hi @kaviyav
*Use Write Range Activity to write DT1 to output excel and give range address as “A1”
*Use Write Range Activity to write DT2 to output excel and give range address as “C1”
*Read the Output Excel to get combined DT.

Hope this hepls

Hi @kaviyav ,

Refer to this video for getting the idea on your use case of merging two data table with nothing in common:

1 Like

its a side by side merge case, so we would not handle with Join DataTable activity or Merge Datatable Activity (result from this would 2 rows, but not the flatten one 1 row)

Suraj described already the Excel way to do this

For datatable / LINQ approach have a look here:

Hi @kaviyav
Check this workflow it might help you.

Consolidate Excel Sheets.xaml (10.3 KB)
Main-Data.xlsx (14.6 KB)

hi Peter,

This Solution work well Thank u :smiling_face_with_three_hearts:

Thank u all for your Solution

Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum