Data360 Analyze

i have an xls import, that all the fields have spaces in the name. I am using the modify fields to set up the data correctly. But, instead of having to manually type the new name using _ instead of space... is there a way to use the rename by pattern? or another fancy trick?

so 

Bill Date = Bill_Date

Import File Name = Import_File_Name

Thanks!

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Attached is an example of how you could standardize the field names to replace spaces with _ and put all field names to uppercase by using a Get Metadata node and a Change Metadata node.

Attached files

Standardize Fieldnames - 11 Dec 2019.lna

Ahh nice! keeping this one in my bag of tricks! (we just got D360 and im working on converting my lavastorm graphs.. not fun)