Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Converting Item Binary classification to it's Source name

MAAbdullahAlMubarah
8 - Asteroid

Dear Experts 

 

 

I have a table for the customer (names) and columns each column represent Item name bought by the customer, The value inside each Item column is binary (0/1) means bought or not bought by the customer.

I need to create a new column (Item Class) that displays the Item name instead of the binary value for each customer, the image below may translate the Idea correctly.

List Of Items.JPG

 

Note: I don't want to use formula tool (if-then-else) because I have around (45) Item.

 

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @MAAbdullahAlMubarah 

 

What about a transpose tool (grouping by Rec No and Customer), followed by a Filter Tool with "Value = 1"?

 

Then Select Tool to rename Item Column and drop Value column.


Cheers, 

Thableaus
17 - Castor
17 - Castor

@MAAbdullahAlMubarah 

 

WF attached.

 

ItemExample.PNG

Cheers,

Labels