Forum Discussion

Jo_Chrq's avatar
Jo_Chrq
Helper I
4 years ago
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 ...
  • amitchandak's avatar
    4 years ago

    Jo_Chrq , create a new table

    distinct(union(distinct(Table1[Campaign ]),distinct(Table1[Campaign ])))