Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
using "apply map" to map the column names.Please help me to undersand with examples
Could you please give an example of what you are trying to achieve?
Please include example data / source data.
TableA:
load
rowno() as field1,
rand()*100 as field2,
1 as field3
AutoGenerate 100;
if you stop the script here you get
FieldNameMap:
Mapping Load * inline [
OldFieldName, NewFieldName
field1, newfield1
field2, newfield2
];
Rename Fields using FieldNameMap;