563443_en-US

liliconcom

How to rename column 1 for every file during multiple file import

Hi guys, 

I wish to rename the first column of every file so that all files can be imported to one single file.

Would anyone be able to help please?

 

Multiple File Import(
 <<SET folder=""></SET>

AnalyticsData TableScriptingRe: How to rename column 1 for every file during multiple file import

Save the data table reference returned from the function call. Use it to refer to the first column when you send the message.

 

dt = Multiple File Import( ... ) << Import Data;

Column( dt, 1 ) << Set Name( "Results" );

Re: How to rename column 1 for every file during multiple file import

A source column is added to each file generated, which will allow you to concatenate all of the files into one file.  If you want to change the name of the first column in each file, that is easy to do after the files have been imported.