To configure at least 2 purchases from the purchase history Table

[vani97]

Hi 

I could able to filter the purchase history with some period of time

But i want filter from this who have made purchase atlease 2 times in the time period

For Eg:

This is the time period i have given to get the purchase history 

Getting records in preview tab Like this and here cust id T110, T111 and T112 made purchase twice 

So in this case as a out pound transition i need to get only 3 records as T110, T111 and T112

Can anyone kindly guide me for this 

Thanks in advance!

[ParthaSarathy · Accepted solution]

Hi @vani97 ,

In Query, use the same filtering condition, and navigate to Query > edit additional data > in output column, add the below 2 fields alone

• @cust_id
• Count(@cust_id)

Enable the 'Group' checkbox for @cust_id in output column.

Then, Advanced Parameters > Enable 'disable automatic adding of primary keys of the targeting dimension' checkbox

So, when you run the workflow, the output if the query will state how many counts a customer id had done a transaction.

After query, use a split and configure filtering condition as count(@cust_ID) greater than or equal to 2

[vani97]

Thanks a lot Its working fine to me