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.
Note: I don't want to use formula tool (if-then-else) because I have around (45) Item.
Solved! Go to Solution.
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,