Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

JOIN to another table based on condition

Hi,   I have a dataset in Power BI with Policy Number, Flag and Program Code i.e. 3 separate columns.   There is another excel table with columns Flag, Policy No/Program Code and other attributes...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

I'd like to suggest you enter to query edit and use 'unpivot columns' on attribute columns of these tables, then you can union two tables to one.

Unpivot columns (Power Query) 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Both the tables do not have the same number of columns hence I cannot do Union on the tables.

 

I tried splitting the table into 2 different tables one with Policy No and one with Program Code, not sure this is working correctly either.

 

Regards,

Vishy

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    If you can please share some dummy data with similar data structure and expected result to help us clarify your requirement and test on it.

    How to Get Your Question Answered Quickly  

    Notice: please do mask or remove sensitive data before share.
    Regards,

    Xiaoxin Sheng