Hi, I am getting a parse error when I am trying to update this formula (\2017\03-March\VALIDATE CASH 03-31-2017.xlsm) into Alteryx Action tool- see formula below.
"\"+tostring([#1])+"\"+tostring([#2])+"\VALIDATE CASH "IF +tostring([#3])+ = ‘Q1’ THEN ‘03-31’ ELSEIF +tostring([#3])+ = ‘Q2’ THEN ‘06-30’ ELSE ‘ERROR’ ENDIF"-"+tostring([#1])+".xlsm|CMLReinsured $"
Solved! Go to Solution.
How about something like:
"\" +
tostring([#1]) +
"\" +
tostring([#2]) +
"\VALIDATE CASH " +
IF tostring([#3]) = "Q1"
THEN "03-31"
ELSEIF tostring([#3]) = "Q2"
THEN "06-30"
ELSE "ERROR"
ENDIF +
"-" +
tostring([#1]) +
".xlsm|CMLReinsured $"
swhitmeyer,
Joe has it cleaned up nicely but just for learning...you have operators in the wrong places and two in a row a couple times. If you look after both the "tostring([#3])" parts you'll see a "+" and a "=". Also the other piece is after "\VALIDATE CASH ".... you go straight to "IF" where you need a "+" right before it :)
Hope this is useful!
Joshua
Thanks! Now I am having an issue with ELSE -
"+ IF tostring([#2]) = "Q1" THEN + tostring([#1])-1 + ELSE =tostring([#1]) ENDIF + "\12-December\swhitmeyer Reserves_Dec16.xlsx”
how about:
"+ IF tostring([#2]) = "Q1" THEN + tostring([#1])-1 + ELSE tostring([#1]) ENDIF + "\12-December\swhitmeyer Reserves_Dec16.xlsx”
I tried that, I am still getting the ELSE parse error :(
"IF tostring([#2]) = "Q1" THEN tostring([#1])-1 ELSE tostring([#1]) ENDIF + "\12-December\swhitmeyer Reserves_Dec16.xlsx”
Hello,
This post has been moved to 'Data Preparation & Blending' from 'Welcome to Community' for greater visibility.
Thanks!
Thank for the quick response! The full formula may help - I am getting a Parse Error at char(0): An operator must be between operands
"\\mmdata\Palm\" IF tostring([#2]) = "Q1" THEN + tostring([#1])-1 + ELSE tostring([#1]) ENDIF + "\12-December\WiltonRe Reserves_Dec16.xlsx"
"\\mmdata\Palm\" + IF tostring([#2]) = "Q1" THEN tostring(ToNumber([#1])-1) ELSE tostring([#1]) ENDIF + "\12-December\WiltonRe Reserves_Dec16.xlsx"
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |