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

Question

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

" field="New_Lenght_for_DB" size="1000" type="V_String" />

Is there a way to do it?

update_data_types.yxmc

caltang · Accepted Answer

Some reading material:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Update-Raw-XML-with-Formula-Use-Cases/td-p/715197

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 Answer

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

I think it helps explain my point above more clearly.