Field not found when loading CSV file

Fri, 08 Aug 2014 16:02:03 GMT

I am trying to load a file with data that looks like the attached "sample data.csv" file.

I am using the following script (Createdwith the Table Files... option) to load the file.

LOAD [Inventory Number],

ID,

[Location Name],

[Local Calls ],

[National Calls ],

[Int'l Calls ],

[Special Calls ],

[National Mobile Calls ],

[Int'l Mobile Calls ],

[Incoming Calls ],

[Total Calls],

[Local Minutes ],

[National Minutes ],

[Int'l Minutes ],

[Special Minutes ],

[National Mobile Minutes ],

[Int'l Mobile Minutes ],

[Incoming Minutes ],

[Total Minutes],

[Local Cost ],

[National Cost ],

[Int'l Cost ],

[Special Cost ],

[National Mobile Cost ],

[Int'l Mobile Cost ],

[Incoming Cost ],

[Total Cost],

[LE-OU],

[REASON FOR ERROR]

FROM

C:\Downloads\sample data.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', header is 4 lines);

When I try to do a reload I get the following error.

Field not found - <Local Calls

LOAD [Inventory Number],

	ID,
	[Location Name],
	[Local Calls	],
	[National Calls	],
	[Int'l Calls	],
	[Special Calls	],
	[National Mobile Calls	],
	[Int'l Mobile Calls	],
	[Incoming Calls	],
	[Total Calls],
	[Local Minutes	],
	[National Minutes	],
	[Int'l Minutes	],
	[Special Minutes	],
	[National Mobile Minutes ],
	[Int'l Mobile Minutes	],
	[Incoming Minutes	],
	[Total Minutes],
	[Local Cost	],
	[National Cost	],
	[Int'l Cost	],
	[Special Cost	],
	[National Mobile Cost	],
	[Int'l Mobile Cost	],
	[Incoming Cost	],
	[Total Cost],
	[LE-OU],
	[REASON FOR ERROR]

FROM

C:\Downloads\sample data.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', header is 4 lines)

Any ideas on how to solve this error?

Re: Field not found when loading CSV file

maxgro — Fri, 08 Aug 2014 16:06:01 GMT

I think because of field name

replace

[Local Calls ],

with

[Local Calls],

and the samefor other fields

Re: Field not found when loading CSV file

Fri, 08 Aug 2014 16:08:38 GMT

This worked! Thank you very much.

topic Re: Field not found when loading CSV file in QlikView

Field not found when loading CSV file

Re: Field not found when loading CSV file

Re: Field not found when loading CSV file