Rename the Column Name

[Karim_Khan]

Hi Team,

     I am trying to load the .csv file and renaming the column but its not allowing me to do the same.

Regards,

KK

MRKachhiaIMP‌swuehl‌gwassenaar‌gargi.bardhan‌ica‌

[gautik92]

which col name you want to change

[Karim_Khan]

any random column you can pick

[rubenmarin]

Hi Karim, in dummy.qvw the parameters of the FROM sentence especifies /t (tab) as separator, meanwhile the data file seems separated by ','.

Drag and drop the file to the document and select ',' as separator:

This way you have all the columns and you can change any name, take care with duplicated column names, there are more than one column named [--- ].

[stigchel]

In the load table files wizard change the delimiter to ","

[Karim_Khan]

Thanks a Lot!!!

[Karim_Khan]

Getting the above error

[rubenmarin]

Column names has a blank space at the end, wizard is retrieving that blank space in the column names but then Qv doesn't find that column.

Remove the blank space at the end of the column names and it should work:

LOAD [Control Date ], --> LOAD [Control Date], 

[MK_QSL]

Can't see properly.Try to attach csv file (without any data... only headers) here..

[#10]

You have extra spaces at the end of each column.. e.g. [Control Date] is coming as [Control Date ], [AFR] is coming as [AFR ]

Try renaming the columns after removing the extra spaces from the Load Statement

e.g. removed extra spaces from Control Date, AFR and reloaded the data -> Untitled.png

      renaming the columns for Control Date and Time and reloaded the data -> Untitled1.png