Hello,I am facing an issue with creating a workflow - I need to refer to the columns 'ID' and 'Phone' and make a new column 'Usage' as shown in the attachment. I tried using the joins but couldn't able to achieve it. Thank's in advance.
Hi @Arvnd-Alteryx
Step 1: Use the summarize tool to take the count
Step 2: Use the Join
Step 3: Use formula tool.
Input the data
IF [Usage]="2"Then "Both"ELSE [Phone]+" only"ENDIF
Many thanks
Shanker V
Hi @Arvnd-Alteryx ,
Here is one way of doing this.
If you want to keep the order, you may join the output back to the original table.
Workflow
Summary Tool configuration
Formula tool configuration
Usage = IF [Concat_Phone] = "Apple" THEN "Apple only"ELSEIF [Concat_Phone] = "Android" THEN "Android only"ELSEIF [Concat_Phone] = "Android,Apple" THEN "Both"ELSE Null()ENDIF
Output
I hope this helps.
Thank you for the quick reply.Yoshiro_FujimoriShankerV
Hi, @Arvnd-Alteryx
I assume that your phone includes duplicates, so I think the following process is more rigorous:
