How do I use transactional data in excel to do market basket analysis using apriori algorithm in Knime?

I am trying to perform the market basket analysis on data from a grocery store, data is available in excel, I am not able to figure out how to use this data in Knime and perform the market basket analysis using the apriori algorithm.

Can somebody help please.



You might want to check out the Market Basket Analysis Use Case and use the XLS Reader to read your data into KNIME Analytics Platform. The hard part if probably to get your data into the right format before applying the Association Rule and/or Frequent Itemset Mining methods.