I am trying to build a standard macro. Here I have an input file which has Player name and its Date of birth. I am trying to add a column called Age.
I created an interface with three radio button options.
- Age By Years
- Age by Months
- Age by Days
the action interface is configure as update the formula as
if (#1) then replace([Destination],"years","days") elseif
(#2) then replace([Destination],"years","months") else
[Destination] endif
However I get the error as
Error: Action (12): Parse Error at char(0): Unknown function "IF"
Solved! Go to Solution.
You need to change the configuration of highlighted action tool to below.
1. Action type: update value
2. Replace value "year". Since you want to replace year.
Output:
This resource might be helpful : https://community.alteryx.com/t5/Interactive-Lessons/Using-Analytic-Applications/ta-p/243106#done
Hope this helps 🙂
That really worked mate!!!