Dynamically change data type

tiverson

I have a report that I input into Alteryx, however my data columns show up as Vstring and I want to change them dynamically to Double each time I upload this report monthly.

Each data column starts with "EAC", then has the period and year listed in the header, ie, EAC 10.2023

Thanks

EAC Comparison TEST.xlsx

alexnajm

Sounds like an Auto Field Tool (alteryx.com)!