Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Create additional column based on 2 other columns condition

Highlighted
Alteryx Partner

 

Hi, 

 

I would like to be able to create the column "overview allocation" based on the information in the column "allocation1" and "allocation2". The idea is to know if the overview allocation is X or 50%X and 50% other allocation. Please find the Excel below.  Could you, please help me to create the formula? 

 

thanks in advance 

 

Officeallocation 1allocation 2Overview allocation
AX X
BBXB/X
C   
DXDD/X
A XX
DX X
Highlighted
Alteryx
Alteryx

Hello Laure,

 

Not sure if I am understanding this correctly but I believe the formula is ...

 

[Allocation 1] + '/' + [Allocation 2]

 

Obviously you need to create a new column called Overview Allocation.

 

Thanks,

Nick

Highlighted
6 - Meteoroid

I believe that the attached workflow should solve your problem. However, just understand that it is not a very dynamic solution meaning that if there are more allocation columns than the 2 you specified, this workflow would no longer work properly and would need to be updated.

 

Hope this helps!

Highlighted
Alteryx Partner

Hi @Laure,

 

Hope this workflow will solve your problem.

Labels