new table copy specific column from multiple table

[mhdilyas2008]

We have imported data from different source and all source have 1 common column.

and we want to create new table and copy data from all source to specific column

Note : i have tried append but im looking for different way.

Example :

	Table1	Table2	Table3
	column1	column2	column3
	name1	name7	name1
	name2	name8	name2
	name3	name3	name3
	name4	name4	name9
	name5	name5	name5
	name6	name6	name10
	newtable
	name1
	name2
	name3
	name4
	name5
	name6
	name7
	name8
	name9
	name10

[v-zhangti · Accepted solution]

Hi, @mhdilyas2008 

You can try the following methods.

Table = DISTINCT(UNION(Table1,Table2,Table3))

Please refer to the attachment.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@mhdilyas2008 ,  Try a new table like

new table= distinct(union(distinct(Table1[column]),distinct(Table2[column]),distinct(Table3[column])))

[mhdilyas2008]

Tried but receive below error