Forum Discussion

smacsween's avatar
smacsween
Frequent Visitor
5 years ago
Solved

Conditional merge columns

i am trying to merge columns based on an IF statement and ISBLANK.  If I have Country name in Table1, use that value, if not, use the Country value from Table2.   I can't see how to do this, I have...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi smacsween ,

     

    Just try this:

    NewTable =
DISTINCT (
    UNION ( DISTINCT ( Table1[Country] ), DISTINCT ( Table2[Country] ) )
)

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

smacsween's avatar
smacsween
Frequent Visitor
5 years ago

What I am trying to do is create a new text column:

 

Let's see if I can describe it differently.  If the text already exists in a column from Table 1, use that. If that column in Table 1 is null or blank, instead take the text from the relevant column in Table 2. 

 

The Union function gives me both together, and I end up with different rows but containing identical data.  I only need one or the other because the field will be present in at least one of the columns, maybe both.

Icey's avatar
Icey
Community Support
5 years ago

Hi smacsween ,

 

Just try this:

NewTable =
DISTINCT (
    UNION ( DISTINCT ( Table1[Country] ), DISTINCT ( Table2[Country] ) )
)

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.