Want to remove Date pattern from Field Names

Question

Hello Experts,

I have a scenario in which monthly files get loaded from client with the date in few columns, so I want to made them independent of dates. So that the formulas depend on the field names should not be  impacted. PFA with the sample data.

Thanks in advance

Alteryx sample for date removal.xlsx

mceleavey · Accepted Answer

Hi @ferha_jafri ,

I've built this using a bit of regex magic (regex is my friend).

Hope this helps.

M.

danilang · Accepted Answer

Hi @ferha_jafri

Using @mceleavey's regex magic, but without the Transpose/Crosstab combo, which is a very expensive pair of operations if you have lots of data.

This workflow operates only of the field names, so it will always take the same amount of time, no matter how many rows in the dataset.  It uses the Field Info tool (one of my favorites) to extract the column metatdata, modifies that and then renames the original columns using a Dynamic Rename.

One thing to note is that after the conversion you have multiple fields with the same name.  Alteryx renames them for you, but you might want to look at renaming them to something like [Net Assets (Current)] and [Net Assets (Prev)] to avoid ambiguity in your workflow

Dan

vizAlter · Accepted Answer

@ferha_jafri — Try this solution using RegEx tool:

(at|[(\s]\d{1,2}\/\d+\/\d+[^(])

Hope this helps!