Forum Discussion
Solved
Create single column table from 2 tables
Hi,
I have two tables, each one has a "Campaign name" column.
They share some campaigns but not all.
I would like to create a table with all campaigns :
Table 1
| Campaign A |
| Campaign B |
| Campaign C |
Table 2
| Campaign A |
| Campaign D |
| Campaign F |
Expected table :
| Campaign A |
| Campaign B |
| Campaign C |
| Campaign D |
| Campaign F |
Is there a way to do so?
Many thanks in advance
Jo_Chrq , create a new table
distinct(union(distinct(Table1[Campaign ]),distinct(Table1[Campaign ])))
2 Replies
Jo_Chrq , create a new table
distinct(union(distinct(Table1[Campaign ]),distinct(Table1[Campaign ])))
GREAT ! thank you
