Forum Discussion

bigrods's avatar
bigrods
Helper III
6 years ago
Solved

Combining and merging fields on same table?

Hi there, I searched but couldn't find anything relating to this. Hope someone could please help:   I have a table with and ID field and numerous fields for various Rules with a 1 or null (1 if the...
Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    Use Power Query.  I suggest selecting all the Rule columns and replace null with 0.

    Then , again with all rule columns selected, choose 'Unpivot' from the transform menu.

    That will give 3 columns ID, Attribute, Value.  You can rename if required.

    Pull ID and Attribute on to a table visual (and Value if required).  Use the filter pane to select Value = 1 for rule violations.

     

HotChilli's avatar
HotChilli
Community Champion
6 years ago

Use Power Query.  I suggest selecting all the Rule columns and replace null with 0.

Then , again with all rule columns selected, choose 'Unpivot' from the transform menu.

That will give 3 columns ID, Attribute, Value.  You can rename if required.

Pull ID and Attribute on to a table visual (and Value if required).  Use the filter pane to select Value = 1 for rule violations.

 

bigrods's avatar
bigrods
Helper III
6 years ago

Great, thanks so much this has worked!