How to get the distinct columns names after perform a full join?

Help Studio
, ,
1

Hi everyone, I’m attempting to perform a full join on two DataTables. However, upon execution, I encounter duplicate column names. My requirement is to obtain only the distinct column names. Can anyone assist me with this issue?

image
image1132×991 82.1 KB

image
image1489×626 59.3 KB

image
image1677×177 16.8 KB

2

Hi,

Can you try FilterDataTable activity to keep necessary columns or to remove unnecessary columns.

image

OR

We can use the following expression to extract necessary columns.
(Please modify content of each item)

dt = dt.DefaultView.ToTable(False,{"NecessaryColumn1","NecessaryColumn2","NecessaryColumn3"})

Regards,

3

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