Need Alteryx Workflow and logic

Question

Hi All,

I need to develop a workflow for a data modelling task for which I need to do data cleaning and preprocessing.

I have the below requirement and request anyone to solve/guide me on this workflow.

Below dataset has customer_id column which may have duplicate and also churn_St column which indicates whether the customer is active or inactive,. Churn_St =1 ,means customer is active and Churn_St=0 customer is inactive. So based on this requirement we have to find whether the duplicate churn_St is same for the customer_id if it is same then we have to merge else consider the churn_St =1 .

For your reference I hereby attach the dataset.

Thanks,

Karthik

Sample_data.xlsx

Ar13f · Answer

Dear @Karthik_7694

The solution I gave may be slightly the same as the solution from Garabujo, I just added a few. I attach my solution.

the result is the data below is for the customer ID that must be considered.

Solution for Karthik_7694.yxmd

Garabujo7 · Answer

Hello @Karthik_7694 ,

I think the unique tool and then a filter will do the trick for you:

Attached is the workflow for your convenience.

Churn.yxzp