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
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		 
					
				
		
 oknotsen
		
			oknotsen
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Could you please give an example of what you are trying to achieve?
Please include example data / source data.
 maxgro
		
			maxgro
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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;

