Error: Action (12): Parse Error at char(0): Unknown function "IF"

[harmeettsiinghsaini]

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"

[atcodedog05 · Accepted solution]

Hi @harmeettsiinghsaini 

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 🙂

[harmeettsiinghsaini]

That really worked mate!!!