Create new column (table) with unique values from two other columns.

Question

Power Query : I want to create a new Table C with a column showing the unique values from two other columns in two different tables A & B. See example below.

I'm sure this is easy but I'm stuck with this one.

Thank you!

anonymous · Accepted Answer

Hi,I solved it this way: Append queries as new-&gt; remove duplicatesletSource = Table.Combine({Table1, Table2}),#"Removed Duplicates" = Table.Distinct(Source)in#"Removed Duplicates"

Forum Discussion

Create new column (table) with unique values from two other columns.

1 Reply

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Create columns group

Creating custom columns keeps returning a structured Table column