Join DataTable without Condition

[kaviyav]

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

[Suraj_B_Shetty (Suraj)]

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

[vishal.kp (vishal)]

Hi @kaviyav ,

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

How to merge columns from different DataTables in UiPath - Tutorial from Start to Finish

[ppr (Peter)]

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:

How to merge the excel table properly

@Vi_ciel have a look on following flow, supporting different rows count e.g. on dt1, dt2 [grafik] With datatable merge details: [grafik] input / output: [grafik] Kindly note: in case of multiple datatables will have the same column name, it has to be handled in advance by making the col names unique find starter help here: SideBySideMerge_AlsoDifferentRCnts.xaml (10.8 KB)

[Soundarya_Guduri]

Hi @kaviyav
Check this workflow it might help you.

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

[kaviyav]

hi Peter,

This Solution work well Thank u

Thank u all for your Solution

[ppr (Peter)]

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