Skip to content

Instantly share code, notes, and snippets.

@treysmithdev
Created August 7, 2021 22:18
Show Gist options
  • Save treysmithdev/3949b7f84ca8cb38c67d31f41cd90ad9 to your computer and use it in GitHub Desktop.
Save treysmithdev/3949b7f84ca8cb38c67d31f41cd90ad9 to your computer and use it in GitHub Desktop.
SET vTP = '------------------'; // Trace Prefix
Trace $(vTP) Loading Data;
data:
Load
'Test' as data_name,
Rand() as random_number
AutoGenerate
(100);
Trace $(vTP) Creating user friendly field names;
field_name_map:
Mapping Load
FieldName(IterNo(),'data') as old_name,
Capitalize(Replace(FieldName(IterNo(),'data'),'_',' ')) as new_name
AutoGenerate
(1)
While
IterNo() < NoOfFields('data')+1;
Rename Fields Using field_name_map;
Trace $(vTP) Fields renamed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment