Forum Discussion

Scarthart's avatar
Scarthart
Icon for Helper I rankHelper I
3 years ago
Solved

Create a table, from others with unique value

Good afternoon, what I want to do is that from 12 tables it takes only one column and shows me only the unique values

This would be the column that I would like to combine with the other tables that are 12

General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • lbendlin's avatar
    lbendlin
    3 years ago

    You could do something like 

    DISTINCT(
UNION(
SELECTCOLUMNS(from table 1),
SELECTCOLUMNS(from table 2),
...
)
)

     

    But it would be much simpler if you had a single table in Power Query and do a deduplication there.

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    You could do something like 

    DISTINCT(
UNION(
SELECTCOLUMNS(from table 1),
SELECTCOLUMNS(from table 2),
...
)
)

     

    But it would be much simpler if you had a single table in Power Query and do a deduplication there.