This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I want to replace specific text within a formula expression. Is there a way to do find and replace of text within a formula expression? I can copy the entire expression outside of Alteryx and quickly do a find and replace and then copy the revised expression back into Alteryx but that is obviously not an ideal solution.
I am actually trying to update several different fields within a formula tool. Each field was initially built using a hardcoded year of 2013 in the formula expression. Here is an example of just one field:
IF (DateTimeMonth([DOD]) < 7) THEN (2013+4) - DateTimeYear([DOD]) + 1 ELSE (2013+4) - DateTimeYear([DOD]) ENDIF
I want to change this formula expression (and all the others) to look like this:
There's no way to automate this in Designer. If you've only got a few changes to make, do them by hand. More than ~10, then .yxmd files are just XML. Find and replace in NotePad++, or even an Alteryx workflow will make all the changes for you. Just make sure to take a backup first.