Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to merge multiple columns

Hello All,   I have two files, In one file there are two columns which has same values, few of them are not matched. I want to do vlookup to those columns values with values in another file but no...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    One solution using DAX.

    Please kindly refer to this article. The main measure is like

     [Is this company a metals company] =

  =IF(
      SUMX(MatchList,
           FIND(
                UPPER(MatchList[Keyword]),
                UPPER(Companies[Company])
                ,,0
               )
          ) > 0,
      “YES!”,
      “Probably Not”
     )

     

     

    Another solution using Query Editor.

     

    1. Left Outer Join

    2. Conditional Column.

     

    See the attached screenshots.

    LEFT OUTER JOIN

    EXPAND COLUMN

    CONDITIONAL COLUMN

    FINAL OUTPUT

     

    Reference: MATCH between 2 tables

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

One solution using DAX.

Please kindly refer to this article. The main measure is like

 [Is this company a metals company] =

  =IF(
      SUMX(MatchList,
           FIND(
                UPPER(MatchList[Keyword]),
                UPPER(Companies[Company])
                ,,0
               )
          ) > 0,
      “YES!”,
      “Probably Not”
     )

 

 

Another solution using Query Editor.

 

1. Left Outer Join

2. Conditional Column.

 

See the attached screenshots.

LEFT OUTER JOIN

EXPAND COLUMN

CONDITIONAL COLUMN

FINAL OUTPUT

 

Reference: MATCH between 2 tables

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.