Merge multiple datatable with values in single column

I want to merge DTs as mentioned in screenshot above. Looking for some help with the same.

Hi @Vivek_Ananth
kindly refer below link hope this helps

There is no link :expressionless:

sry @Vivek_Ananth
missed it kindly refresh now

It doesn’t help. There is no common column available in DTs explained in video.

Hi @Vivek_Ananth

please do refer this

Hi @Vivek_Ananth
please find an example
Join.xaml (13.6 KB)
Hope this gives you an idea

Find starter help here:
FullJoin_MergeToLeft_JoinWithTableList_1Col.xaml (17.3 KB)

1 Like