How to convert data into transaction format for Market Basket Analysis

Question

Hello:

I will appreciate any pointers / examples to convert store sales data into Transaction data to be able to run Market Basket Analysis in Alteryx.

Attached is a sample file and an example workflow. The output has commas at the end. How do I remove commas?

Thanks

Transaction.csv

How to convert data to appropriate format for market basket analysis.yxmd

ccanterman · Accepted Answer

Alternately, throw a TrimRight around your Itemset formula and set it to remove all commas on the right

I like the Transpose since it scales better. Each time you add new fields into your Transactions (Field_6, Field_7, etc), you'll need to update your Formula. Whereas the Transpose will just handle it.

prakashatutd · Accepted Answer

Many Thanks for this excellent approach