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;
