Can Alteryx help filter out product with billing consecutive two weeks

Can Alteryx help filter our product.yxmd

If i understood well your requirements, here it is. Please take a look.

Sample Data Altyerx for billing frequence.xlsx

@Felipe_Ribeir0 Thanks so much for providing the flow. Really helpful. I see you are utilize the date to form the solution. Actually, I have the billing date available and have updated it in the sample data. Just wondering if flow could be updated more simpler to achieve the same result.

Each year there is 53 billing week and the first billing week always from 1 Jan - 7Jan and continue. The goals is to pick up any product code has been billed continually in two billing week within 12 billing weeks will be considered as weekly. Please refer uploaded the data here. Many Thanks and Much appreciate your help

Can Alteryx help filter our product.yxzp

Take a look at the attached workflow.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

Sample Data Altyerx for billing frequence with customer.xlsx

@Felipe_Ribeir0

This flow is not working if we have additional column like customer. See new data, for product F if we billed two different customers, the flow would consider product F has been billed twice and mark it as weekly. The goal is to focus on the product code, what are product code has been billed consecutive two weeks. doesn't matter for which customer. Can Alteryx do that. Many Thanks

All comments

acarter881

Hey, @Apple_Orange. I took a glance at your data and I believe there are several ways to solve it in Alteryx. Have you tried the Multi-Row Formula tool? As a potential hint, you may need to group by the Product Code field.

Can Alteryx help filter our product.yxmd

If i understood well your requirements, here it is. Please take a look.

Hi Acarter881, Thanks so much, I haven't used it before. Would you happen to have the Alteryx flow to elaborate what you mean. Many Thanks

Sample Data Altyerx for billing frequence.xlsx

Can Alteryx help filter our product.yxzp

Take a look at the attached workflow.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

@Felipe_Ribeir0 Cannot see the difference on this flow. Would you happen to use the updated data with billing date to simplify the flow?