Copy column from Multiple table to one Datatable

I have 3 data tables with multiple columns. I want extract values from a single column (i.e column name "Store) from each DT and save it to new datatable.

Any help is appreciated.

Hi,

Can you share sample input and expected output as file? It’s no problem if dummy data.

Regards,

a.xlsx (8.9 KB)
b.xlsx (8.8 KB)
c.xlsx (8.8 KB)

File attached and Outcome I want is ("Booking Shop/Team)

image

Hi,

In this case, we can use MergeDataTable activity as the following. Can you try this?

Sample20221006-1.zip (22.6 KB)

Regards,

Thanks Yoichi . Ya I am currently using this method thought there might an easy way to do it via using Linux.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.