Forum Discussion
Cognos
4 years agoRegular Visitor
Dummy variable problem
Hello everyone, need some help, have this table: X2 DUMMY_1 DUMMY_2 DUMMY_3 X4 X5 ID 12334 1 1 0 1234 45566 ID2 1233 1 0 1 125 123 ID4 564 0 0 1 123 1231 I...
Tanushree_Kapse
4 years agoImpactful Individual
Hi Cognos ,
-Transform the table in the Power query:
-Unpivot the three DUMMY columns
-Close and Apply
-Take a table visual
-Pull the new columns in it.
Mark this as solution. if I answered your que. Kudos are always appreciated.
Thanks.