topic Re: Rename the Column Name in QlikView

Rename the Column Name

Karim_Khan — Mon, 05 Oct 2015 10:44:46 GMT

Hi Team,

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

Regards,

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

Re: Rename the Column Name

gautik92 — Mon, 05 Oct 2015 10:47:17 GMT

which col name you want to change

Re: Rename the Column Name

Karim_Khan — Mon, 05 Oct 2015 10:48:59 GMT

any random column you can pick

Re: Rename the Column Name

rubenmarin — Mon, 05 Oct 2015 10:56:06 GMT

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 [--- ].

Re: Rename the Column Name

stigchel — Mon, 05 Oct 2015 10:59:06 GMT

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

Re: Rename the Column Name

Karim_Khan — Mon, 05 Oct 2015 11:00:38 GMT

Thanks a Lot!!!

Re: Rename the Column Name

Karim_Khan — Mon, 05 Oct 2015 11:09:17 GMT

Getting the above error

Re: Rename the Column Name

rubenmarin — Mon, 05 Oct 2015 11:20:05 GMT

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],

Re: Rename the Column Name

MK_QSL — Mon, 05 Oct 2015 11:24:51 GMT

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

Re: Rename the Column Name

Mon, 05 Oct 2015 11:25:21 GMT

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

Re: Rename the Column Name

Karim_Khan — Mon, 05 Oct 2015 11:36:48 GMT

Tnx

Re: Rename the Column Name

stigchel — Mon, 05 Oct 2015 11:42:39 GMT

There are some spaces in the column names you need to remove and there are some duplicate column names. Either skip these or don't load the header and rename the fields afterwards using a map constructed from the header e.g.

Map:

Mapping Load * Inline [From, To

@1,Control Date

@2,Control Time

@3,Engine Speed (rpm)

@4,Main Gen Power (W)

@5,TET#1 (ÁC)

@6,TET#2 (ÁC)

@7,Turbine Exit Temp (ÁC)

@8,Compressor In Temp (ÁC)

@9,Valve Position Feedback %

@10,AFR

@11,Wair (pph)

@12,Ambient Pressure (kPa)

@13,Wenergy (btu/sec)

@14,Incident Record

@15,Combustor Starts

@16,Starts

@17,TET Setpoint (ÁC)

@18,Hours

@19,Combustor Time

@20,System Severity Level

@21,System State

@22,Sys Config/Eng State

@23,Power Enable

@24,RFC Power (W)

@25,Discrete Outputs

@26,Discrete Inputs

@27,Main Board Temp (ÁC)

@28,Power Demand (W)

@29,Power Supply Voltage (V)

@30,Start Command (0/1)

@31,RFC Command

@32,RFC Control Mode

@33,Fuel Inlet P LP (kPa)

@34,Fuel Outlet P LP (kPa)

@35,RFC Temp (ÁC)

@36,RFC Speed (rpm)

@37,RFC Current FB (A)

@38,RFC Injector State

@39,Fuel Valve Command (%)

@40,Fuel Inlet Pres (kPa)

@41,Fuel Valve Inj State

@42,Fuel Valve Temp (ÁC)

@43,Fuel Valve Ex P (kPa)

@44,Bat Therm.Temp (ÁC)

@45,Bat PM Temp (ÁC)

@46,BC Heatsink T (ÁC)

@47,BC Board T (ÁC)

@48,Bat SOC (%)

@49,Bat Base SOC (%)

@50,Bat Ideal SOC (%)

@51,Bat Last SOC (%)

@52,Bat Leg A (A)

@53,Bat Leg B (A)

@54,Bat Leg C (A)

@55,Bat Avg Current (A)

@56,Bat Volts (Vdc)

@57,BC DC Bus (V)

@58,Bat Avg Power (W)

@59,Bat kWH (kWH)

@60,Battery State

@61,Charge Type

@62,Bat Charg Phase No.

@63,Bat Charg Cur Dmd (A)

@64,Bat Charging Volt Dmd (V)

@65,Inv DC Bus Volts (Vdc)

@66,Inv Direct Curr (A)

@67,LFC Pump PWM (%)

@68,AA Pressure (kPa)

@69,LFC Injector State

@70,LFC Pressure Command (kPa)

@71,LFC Pressure Feedback (kPa)

@72,System Prime Status

@73,LFC Prime

@74,Boost Pump

@75,LFC Prime state

@76,Boost Pump Status

@77,Drain Pump Status

@78,Prime Sol. Status

@79,RFC DC Bus (V)

@80,LFC Pump Speed (%rpm)

@81,81 ---

@82,Inv Quadrature Curr (A)

@83,Output Frequency (Hz)

@84,Output Phase A Mag (V)

@85,Output Phase B Mag (V)

@86,Output Phase C Mag (V)

@87,Output Current Phase A (A)

@88,Output Current Phase B (A)

@89,Output Current Phase C (A)

@90,Output Current Neutral (A)

@91,Output Voltage Phase A (V)

@92,Output Voltage Phase B (V)

@93,Output Voltage Phase C (V)

@94,Output Power Phase A (W)

@95,Output Power Phase B (W)

@96,Output Power Phase C (W)

@97,Output Power (W)

@98,Inv Heat Sink Temp (ÁC)

@99,Output Current Limit (A)

@100,Gen Direct Current (A)

@101,Gen Quad Current (A)

@102,Gen Direct Voltage (V)

@103,Gen Quadrature Voltage (V)

@104,Gen Speed Cmnd (rpm)

@105,Brake Voltage Cmnd (V)

@106,Gen Current Feedback (A)

@107,Gen Current Limit (A)

@108,FCB Fault Word3_2

@109,Brake Temp (ÁC)

@110,110 ---

@111,Gen Power Out (W)

@112,Gen Speed (rpm)

@113,Gen DC Bus Voltage (V)

@114,Gen Command Value

@115,Bat Total Energy (kWH)

@116,116 ---

@117,Last Eq.Charge (mm.dd.yy)

@118,Pilot Inj.Switch Hi (kW)

@119,Pilot Inj.Switch Lo (kW)

@120,Premix Inj.Switch Hi (kW)

@121,Premix Inj.Switch Lo (kW)

@122,Bat No. Eq. Charges

@123,Meter Run/Stop

@124,Meter Watts In (W)

@125,Meter Watts Out (W)

@126,Meter VAR In (VAR)

@127,Meter VAR Out (VAR)

@128,128 ---

@129,MPac Min Pw Capacity

@130,MPac Spinning Reserve

@131,Turbine number

@132,MultiPac Enable

@133,MPac 1-32 Units Locked

@134,MPac 33-64 Units Locked

@135,MPac 65-96 Units Locked

@136,MPac 97-128 Units Locked

@137,CHP Mode

@138,CHP State

@139,CHP Water Setpoint (ÁC)

@140,CHP Water Inlet Temp (ÁC)

@141,CHP Water Outlet Temp (ÁC)

@142,CHP Board Temp (ÁC)

@143,CHP Bridge Current (A)

@144,CHP Status

@145,CHP Water Flow (LPS)

@146,CHP Temperature Feedback (ÁC)

@147,FCM State

@148,FCM Command %

@149,FCM Up Pressure (kPa)

@150,FCM Sol State

@151,Injector State

@152,FCM Board Temp (ÁC)

@153,FCM Cold Junc T (ÁC)

@154,FCM Pump Speed (rpm)

@155,FCM Pwr Supply (Vdc)

@156,FCM 5.0 V (Vdc)

@157,FCM Switch Power (Vdc)

@158,FCM 2.5 VREF (Vdc)

@159,FCM PWM A (%)

@160,FCM PWM B (%)

@161,FCM CUR A (A)

@162,FCM CUR B (A)

@163,Gen IGBT A Temp (ÁC)

@164,Gen IGBT B Ttemp (ÁC)

@165,Gen IGBT C Temp (ÁC)

@166,Gen IGBT Brake Temp (ÁC)

@167,Gen ICB Board Temp (ÁC)

@168,Gen PDM1 Board Temp (ÁC)

@169,Gen PDM2 Board Temp (ÁC)

@170,Inv IGBT A Temp (ÁC)

@171,Inv IGBT B Temp (ÁC)

@172,Inv IGBT C Temp (ÁC)

@173,Inv IGBT N Temp (ÁC)

@174,Inv ICB Board Temp (ÁC)

@175,FCB Hardware ID value

@176,FCB Fault Word1

@177,FCB Fault Word2

@178,FCB H-Bridge CH A PWM (%)

@179,FCB H-Bridge CH B PWM (%)

@180,FCB Solenoid Command

@181,FCB Solenoid Status

@182,FCB Control Power Supply (V)

@183,FCB Switched Power Supply (V)

@184,FCB 5V Analog Power (V)

@185,FCB 2.5V ADC Ref (V)

@186,FCB H-Bridge CH A Current (Amp)

@187,FCB H-Bridge CH B Current (Amp)

@188,FCB State Commanded

@189,FCB Actual State

@190,FCB Enable

@191,FCB Mode

@192,FCB Fault Word3_1

@193,FCB Fault Word4

@194,Sec Bat Therm.Temp (ÁC)

@195,Sec Bat PM Temp (ÁC)

@196,Sec BC Heatsink T (ÁC)

@197,Sec BC Board T (ÁC)

@198,Sec Bat SOC (%)

@199,Sec Bat Base SOC (%)

@200,Sec Bat Ideal SOC (%)

@201,Sec Bat Last SOC (%)

@202,Sec Bat Leg A (A)

@203,Sec Bat Leg B (A)

@204,Sec Bat Leg C (A)

@205,Sec Bat Avg Current (A)

@206,Sec Bat Volts (Vdc)

@207,Sec BC DC Bus (V)

@208,Sec Bat Avg Power (W)

@209,Sec Bat kWH (kWH)

@210,Sec Battery State

@211,Sec Charge Type

@212,Sec Bat Charg Phase No.

@213,Sec Bat Charg Cur Dmd (A)

@214,Sec Bat Charging Volt Dmd (V)

@215,Sec Bat Total Energy (kWH)

@216,Sec Last Eq.Charge (mm.dd.yy)

@217,Sec Pilot Inj.Switch Hi (kW)

@218,Sec Pilot Inj.Switch Lo (kW)

@219,Sec Premix Inj.Switch Hi (kW)

@220,Sec Premix Inj.Switch Lo (kW)

@221,Sec Bat No. Eq. Charges

@222,In2 DC Bus Volts (Vdc)

@223,In2 Direct Curr (A)

@224,In2 Quadrature Curr (A)

@225,In2 Out Frequency (Hz)

@226,In2 Out Phase A Mag (V)

@227,In2 Out Phase B Mag (V)

@228,In2 Out Phase C Mag (V)

@229,In2 Out Current Phase A (A)

@230,In2 Out Current Phase B (A)

@231,In2 Out Current Phase C (A)

@232,In2 Out Current Neutral (A)

@233,In2 Out Voltage Phase A (V)

@234,In2 Out Voltage Phase B (V)

@235,In2 Out Voltage Phase C (V)

@236,In2 Out Power Phase A (W)

@237,In2 Out Power Phase B (W)

@238,In2 Out Power Phase C (W)

@239,In2 Out Power (W)

@240,In2 Heat Sink Temp (ÁC)

@241,In2 Out Current Limit (A)

@242,FCB Fault Word5

@243,FCB Fault Word6

@244,FCB Engine Lit

@245,Start Fuel Pressure (kPa)

@246,Air Compressor Presure (kPa)

@247,Debug Command 1

@248,Debug Command 2

@249,Debug Command 3

@250,Debug Command 4

];

LOAD @1,

@2,

@3,

@4,

@5,

@6,

@7,

@8,

@9,

@10,

@11,

@12,

@13,

@14,

@15,

@16,

@17,

@18,

@19,

@20,

@21,

@22,

@23,

@24,

@25,

@26,

@27,

@28,

@29,

@30,

@31,

@32,

@33,

@34,

@35,

@36,

@37,

@38,

@39,

@40,

@41,

@42,

@43,

@44,

@45,

@46,

@47,

@48,

@49,

@50,

@51,

@52,

@53,

@54,

@55,

@56,

@57,

@58,

@59,

@60,

@61,

@62,

@63,

@64,

@65,

@66,

@67,

@68,

@69,

@70,

@71,

@72,

@73,

@74,

@75,

@76,

@77,

@78,

@79,

@80,

@81,

@82,

@83,

@84,

@85,

@86,

@87,

@88,

@89,

@90,

@91,

@92,

@93,

@94,

@95,

@96,

@97,

@98,

@99,

@100,

@101,

@102,

@103,

@104,

@105,

@106,

@107,

@108,

@109,

@110,

@111,

@112,

@113,

@114,

@115,

@116,

@117,

@118,

@119,

@120,

@121,

@122,

@123,

@124,

@125,

@126,

@127,

@128,

@129,

@130,

@131,

@132,

@133,

@134,

@135,

@136,

@137,

@138,

@139,

@140,

@141,

@142,

@143,

@144,

@145,

@146,

@147,

@148,

@149,

@150,

@151,

@152,

@153,

@154,

@155,

@156,

@157,

@158,

@159,

@160,

@161,

@162,

@163,

@164,

@165,

@166,

@167,

@168,

@169,

@170,

@171,

@172,

@173,

@174,

@175,

@176,

@177,

@178,

@179,

@180,

@181,

@182,

@183,

@184,

@185,

@186,

@187,

@188,

@189,

@190,

@191,

@192,

@193,

@194,

@195,

@196,

@197,

@198,

@199,

@200,

@201,

@202,

@203,

@204,

@205,

@206,

@207,

@208,

@209,

@210,

@211,

@212,

@213,

@214,

@215,

@216,

@217,

@218,

@219,

@220,

@221,

@222,

@223,

@224,

@225,

@226,

@227,

@228,

@229,

@230,

@231,

@232,

@233,

@234,

@235,

@236,

@237,

@238,

@239,

@240,

@241,

@242,

@243,

@244,

@245,

@246,

@247,

@248,

@249,

@250

FROM

(txt, codepage is 1252, no labels, delimiter is ',', msq, filters(

Remove(Row, Pos(Top, 1))

));

RENAME Fields using Map;

Re: Rename the Column Name

stigchel — Mon, 05 Oct 2015 11:45:52 GMT

My comment is being moderated, please see attached qvw.

In this qvw I load the csv without header as there are duplicates and spaces in the header names. I also created a map to rename the fields afterwards, constructed with the original header.