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_Date | AM | PM |
04/02/2014 | On Territory | On Territory |
02/01/2013 | Meeting other | Meeting other |
17/01/2016 | Weekend | Weekend |
10/02/2013 | Weekend | Weekend |
09/10/2014 | On Territory | On Territory |
07/05/2012 | Bank Holiday | Bank Holiday |
07/05/2017 | Weekend | Weekend |
08/01/2017 | Weekend | Weekend |
20/03/2014 | On Territory | On Territory |
Solved! Go to Solution.
@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
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 :-)