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

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"

Alteryx IF.PNG

Expression

Accepted answers

apathetichell

hmmmm - this is probably easier using standard workflow tools instead of making all of your conditional logic and value swapping in update tools. it's easier to troubleshoot there.

atcodedog05

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 🙂

FirstMacro_M_Adv-app.yxwz

FirstMacro_M_Adv.yxmc

All comments

apathetichell

I think I encountered this once before as some temporary error - so assuming you have your action tool configured probably (update value with formula) - try it again this time using the formula build interface and selecting the IF function after expanding... I think technically in the Alteryx engine it's IF THEN ELSE ENDIF and while it usually is fine with lower case sometimes it has minor hiccups..

also I believe it will want #1,#2,#3 called as [#1],[#2],[#3]...

atcodedog05

Hi @harmeettsiinghsaini

Radio button might not be the best option for your scenario. I would suggest use of drop down tool. And to use the connections input directly you can connect directly to Q anchor. Refer below [#1] is directly input from connection and is compared with days,months.

Workflow:

Output:

Hope this helps 🙂

years app change.yxwz

atcodedog05

Hi @harmeettsiinghsaini

We can make it more sophisticated by changing the formula to below which is directly replace year with string in [#1]

Hope this helps 🙂

years app change - v2.yxwz

harmeettsiinghsaini

Hi,

Tried using Drop down list but again it shows the same error.

apathetichell

hmmmm - this is probably easier using standard workflow tools instead of making all of your conditional logic and value swapping in update tools. it's easier to troubleshoot there.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703