community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

column calculation

Hi

 

I am new to Alteryx and have the following question. I would like to show a new column in the table where AM is On Territory = 0.5 and PM is On Territory = 0.5 and Full Day = sum of both. Where AM and PM <> On Territory = 0.

 

E.G. 04/02/2014 AM 0.5, PM 0.5, Full Day 1

        17/01/2016 AM 0, PM 0, Full Day 0

 

Hope this makes sense. Thanks

 

 

Close_DateAMPM
04/02/2014On TerritoryOn Territory
02/01/2013Meeting otherMeeting other
17/01/2016WeekendWeekend
10/02/2013WeekendWeekend
09/10/2014On TerritoryOn Territory
07/05/2012Bank HolidayBank Holiday
07/05/2017WeekendWeekend
08/01/2017WeekendWeekend
20/03/2014On TerritoryOn Territory

 

 

@Escaped_Goat There are numerous ways to accomplish this. I've chosen to use a multi-field tool and a formula tool. A single formula tool would have worked as well. I've attached my alteryx file.

 

 

Thank you for replying so quickly. Unfortunately I am unable to open your workflow as running 32 bit version until my laptop is upgraded. I will have a play with the multi-field tool and see how I get on

Magnetar
Magnetar

Hi!

Use a formula tool to create a new field, called Full Day (data type needs to be numeric)

IIF([AM]="On Territory", .5, 0) + IIF([PM]="On Territory", .5, 0)

This subsitutes a 0.5 for On Territory, and a 0 for everything else. Haven't tested it, but it should work.

Best,
Esther

Thank you! that worked :-)

Labels