Creating a new colum by refering to other columns.

[Arvnd-Alteryx]

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.

[ShankerV · Accepted solution]

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

[Yoshiro_Fujimori]

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.

[Arvnd-Alteryx]

Thank you for the quick reply.
Really appreciate your help @Yoshiro_Fujimori
ShankerV

[flying008]

Hi, @Arvnd-Alteryx 

I assume that your phone includes duplicates, so I think the following process is more rigorous:

Input			Output
ID	Phone		ID	Phone	Usage
111	Android		111	Android	Both
222	Apple		222	Apple	Apple only
333	Apple		333	Apple	Both
111	Apple		111	Apple	Both
444	Android		444	Android	Android only
555	Android		555	Android	Android only
666	Android		666	Android	Android only
333	Android		333	Android	Both
777	Apple		777	Apple	Apple only
888	Apple		888	Apple	Apple only