Filtering by the appearance in rows

Hi,

I am trying to filter only those customers, who first bought A product or first brought B product and secondly bought A product to see what else they have brought after buying A.

This is a sample of data I have:

Sample data.jpg

Required result should look like this:

Sample result.jpg

Could this be done in Alteryx?

Preparation

Accepted answers

jdunkerley79

Odd definitely filters that on mine:

Have attached it again in case I attached wrong version!

Keep Purchases 2.yxmd

All comments

jdunkerley79

Just to make sure I understand.

For each customer, you want to keep the records of when they bought product A plus the purchase before and after product A.

If this is the case then yes do-able within Alteryx using a MutliRow formula. An expression like:

'A' IN ([Row-1:Product_ID], [Product_ID], [Row+1:Product_ID])

grouped by Customer_ID should do what you need.

Sample attached

Keep Purchases.yxmd

ievpal

Hi,

Not exactly.

What I`am interested to see is:

If a customers first purchase was A product or he bought A product after firstly buying B product then I want to see his whole purchases history.

If a customer bought C product first I am not interested in him.

In my real data set I have 5 products, so if the customers first purchase was D or E I am not interested in those either.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703