Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

When i try to import CSV file I Alway get error msg on one field unable to import in ?

Hi All

I have a Excel CSV raw data file , when i try to import wizard , i get the below script :-

Directory;
LOAD [Customer/Vendor Code],
[Customer/Vendor Name],
[Payment Terms Code],
[Outstanding w/o Tax (LC)],
[AR Invoice Number],
[AR Invoice Date],
SlpName,
[Industry_Description

],
[Sub-Industry]
FROM
..\..\..\Dropbox\QV_RAW_ISDN\AR_PM.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Notice that second last field , the Bracket go to next 2 row down.

When i click reload script , i get below error msg :-

Field not found - <Industry_Description

>
Payment:

May i know it there any way i can aviod the above error ?

Paul Yeo

1 Solution

Accepted Solutions
Vegar
Partner
Partner

I don't get the same error as you when loading the csv in QlikView desktop. Using this script.

LOAD 
[Customer/Vendor Code],
[Customer/Vendor Name],
[Payment Terms Code],
[Outstanding w/o Tax (LC)],
[AR Invoice Number],
[AR Invoice Date],
SlpName,
[Industry_Description

],
[Sub-Industry]
FROM
AR_PM.csv
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

 

A walkaround if you still have trouble with the csv is to don't use the header names like this.

LOAD 	
	@1 AS [Customer/Vendor Code],
	@2 AS [Customer/Vendor Name],
	@3 AS [Payment Terms Code],
	@4 AS [Outstanding w/o Tax (LC)],
	@5 AS [AR Invoice Number],
	@6 AS [AR Invoice Date],
	@7 AS SlpName,
	@8 AS [Industry_Description],
	@9 AS [Sub-Industry]
FROM
AR_PM.csv
(txt, codepage is 28591, no labels, delimiter is ',', msq, header is 1 lines);

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

4 Replies
paulyeo11
Master
Master
Author

Hi All

I try to upload the raw data CSV is not allow , so i ZIP it and post here . Hope some one can test for me.

Paul

 

paulyeo11
Master
Master
Author

Hi All

When I open the excel CSV file , i notice that the problem field have some hidden space . which cause the problem. 

 

error msg on ar pm.png

Vegar
Partner
Partner

I don't get the same error as you when loading the csv in QlikView desktop. Using this script.

LOAD 
[Customer/Vendor Code],
[Customer/Vendor Name],
[Payment Terms Code],
[Outstanding w/o Tax (LC)],
[AR Invoice Number],
[AR Invoice Date],
SlpName,
[Industry_Description

],
[Sub-Industry]
FROM
AR_PM.csv
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

 

A walkaround if you still have trouble with the csv is to don't use the header names like this.

LOAD 	
	@1 AS [Customer/Vendor Code],
	@2 AS [Customer/Vendor Name],
	@3 AS [Payment Terms Code],
	@4 AS [Outstanding w/o Tax (LC)],
	@5 AS [AR Invoice Number],
	@6 AS [AR Invoice Date],
	@7 AS SlpName,
	@8 AS [Industry_Description],
	@9 AS [Sub-Industry]
FROM
AR_PM.csv
(txt, codepage is 28591, no labels, delimiter is ',', msq, header is 1 lines);

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

paulyeo11
Master
Master
Author

Hi Sir

Thank you very much. It work fine now.

Paul