Hi there,
I have been using the Regex Tool (under Parse) to clean up multiple columns that needs cleaning.
I am wondering is there a way to apply the Regex on several columns all at once?
For examples, most of the columns should only be an integer value (for scores) however they are coming up as either Dates (e.g. 2017-02-02 when it should be just 2) or even some texts like "10-TEXT=10" which I use regex to turn it into just 10.
As you can imagine, to apply the above regex expressions over 20-30 fields are very time consuming/messy.
Surely there is a better way to do this in Alteryx?
Thanks,
Viv
Solved! Go to Solution.
theres 3 regex functions that can be used in a expression builder (Formula). REGEX_MATCH(), REGEX_REPLACE() and REGEX_COUNT(). Use which ever is appropriate in a multi-field formula tool and apply your regex pattern to all the fields you check.
Hope this helps!
Jimmy
This does not work for PARSE. I have to parse 12 different fields - apparently the only solution is to the use the "REGEX" tool under the "Parse" menu 12 times.
Hi, you could try a Transpose followed by one regex on Value, then Cross Tab back?
sounds interesting - will try when fresh in the morning and let you know 🙂
@davidoc you can use record id to transpose and then crosstab back. Here is a simple example attached.