Want to remove Date pattern from Field Names

[ferha_jafri]

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

[messi007]

@ferha_jafri,

If the columns are always on the same position you can use the option below:

and then use the select tool to rename then create your formulas

Hope this helps,

Attached the workflow,

Regards

[mceleavey · Accepted solution]

Hi @ferha_jafri ,

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

Hope this helps.

M.

[danilang · Accepted solution]

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 solution]

@ferha_jafri — Try this solution using RegEx tool:

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

Hope this helps!