Sorting association rules events data

[Former Member]

Continuing the association rules analysis began in a previous post , I get the following error:

2016-08-30 15:23:36

Error

The transactions data set is not sorted by session key: it is impossible

to use the chunks learning strategy.

The session (2001997186) is not contiguous.

I spoke to my data team about the issue and not only are the transactions not sorted by transaction number, but they are coming from different sources that use different formats for the transaction number.  So each transaction does have a unique identifier, but they are not continuous and will never be sorted in order in our HANA database.  How can I proceed with a market basket analysis?

[marc_daniau · Accepted solution]

Could you share the Data Description files for both the Reference table and the Event table ?

Or if you prefer, you can send screenshots.

[Former Member · Accepted solution]

We determined that the transaction numbers must appear in the same order in both the reference table and the events table for the algorithm to run.

[achab · Accepted solution]

Hello Grace, is your question resolved? Thanks & regards Antoine