How to update the expression of a formula, using a macro?

[ctozzi]

Hello,

I would like to have a macro, that will update an expression in a formula tool, according to an xml code.

My input would be something like this:

  <FormulaField expression="IF [Type] = 'V_String' THEN 'VARCHAR2(2000 CHAR)' ELSE [Size] ENDIF&#xA;&#xA;" field="New_Lenght_for_DB" size="1000" type="V_String" />

Is there a way to do it?

[caltang · Accepted solution]

Some reading material: 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Update-Raw-XML-with-Formula-Us...

You can configure the action tool to update XML. But you need to check where exactly you are updating because it could have unintended changes if the area you’re changing is similar elsewhere in the XML.

[caltang · Accepted solution]

A good comment by @danilang here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Update-action-tool-using-Raw-X...

I think it helps explain my point above more clearly.