HI guys,
Been trying to create a market basket analysis using splunk. Simply, I would like to build a pivot that would show me what other items were bought when Product A was purchased.
I have a CSV with two columns, Transaction IDs and Products names. If a transaction had more than 1 item purchased the id will be listed with as many unique items as possible.
Example
ID-32 Product A
ID 32 Product B
ID 33 Product G
ID 33 Product B
ID 34 Product A
ID 34 Product J
etc.
I am sure Splunk can do it. I just can't wrap my brain around it right now.
Thank you.
... View more