Text Input Mapping for Formula

cp2019

Hi All,

I have a formula tool that has the following formula to mark items as shown below.and put it into a new field called "Remove". Then I would just have a filter set based on boolean logic to get rid of these items.

Is there a way to make this easier and have a text input mapping for the quoted text removals in one reference field instead of a user having to manually edit this formula based on changing needs?

Then if there's others, they can just add it to the reference field in the text input mapping instead of changing the formula.

Thank you!!!

if Contains([Label],"AOI") then 1
elseif Contains([Label], "HCT") then 1
elseif Contains([Label], "AMP") then 1
elseif Contains([Label], "Total") then 1
elseif Contains([Label], "US91_DEC18YTDP&L_US") then 1
elseif IsEmpty([Label]) then 1
elseif StartsWith([Entity], "5") then 1 else 0 endif

AngelosPachis

Hi @cp2019 ,

You can use a find & replace tool to find whether any part of the strings in the Text Input Mapping are contained in your input.

Then you can use a filter tool to remove them. Not sure about how you can tackle entity and make filtering dynamic, probably that might have to be more manual.

Hope that helps,

Angelos

example.yxmd