Capitalise the header/field names to UPPERCASE and replace the spaces

[Shaiy10]

Hi All,

I am taking an input from an excel file where the header/field names are as below

Function / Function ID / Region / Region ID

there are too many tables and too many columns to rename manually

i need a solution to convert all the header/field names to UPPERCASE and replace the spaces with an underscore as the header names in my oracle table appear that way

for eg. the above header names should convert to the below

FUNCTION / FUNCTION_ID / REGION / REGION_ID

is this possible in alteryx?

thanks,

[MelissaTeal]

The Data Cleaning Tool has a 'Modify Case' selection.