topic Re: csv file load issue identical field names different data in QlikView

csv file load issue identical field names different data

Tue, 22 Jan 2013 09:59:09 GMT

Wondered if you could help me out with this issue I am having with a csv file load. I am loading a csv extract from an SAP product table that has 2 identical field names but different data in each field. The first field is an alpha numeric code and the second is a description.

The issue

When I load this file and rename these fields to Product code and Product description, they are both populated with the description data from the second field. If you comment out the second field, it still loads the description from the second field and not the code from the first field. I have never come across this issue and I am assuming that it is skipping the contents of the first field for some reason. Bizarre!

I have tried separating the columns, but it still happens. If you load the file without the embedded column names, it loads as normal.

Attached is an example of what I am loading. Am missing something obvious

Cheers

Brett

Re: csv file load issue identical field names different data

swuehl — Tue, 22 Jan 2013 10:30:56 GMT

Try

Directory;

LOAD @1 as Material,

@2 as [Product Hierarchy Code],

@3 as [Product Hierarchy Description],

@4 as [SG GRP],

@5 as Manufacturer

FROM

SalesProducts.csv

(txt, codepage is 1252, no labels, delimiter is ',', msq, header is 1 lines);

Re: csv file load issue identical field names different data

Tue, 22 Jan 2013 10:42:31 GMT

Hi,

use below script to get the required:

Directory;

LOAD @1 as Material,

@2 as [Product Hierarchy Code],

@3 as [Product Hierarchy Descriptio],

@4 as [SG GRP],

@5 as Manufacturer

FROM

SalesProducts.csv

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

Remove(Row, Pos(Top, 1))

));

Niranjan M.

Re: csv file load issue identical field names different data

Tue, 22 Jan 2013 21:16:55 GMT

Thanks

I have implemented this solution but its annoying when you have a bunch of columns to rename.

Re: csv file load issue identical field names different data

Mon, 11 Feb 2013 12:09:58 GMT

I have placed a support call as this may be a bug

Cheers

Brett

Re: csv file load issue identical field names different data

rbecher — Mon, 11 Feb 2013 12:39:19 GMT

I think this is not a QlikView bug. However there is a programmatically solution for this kind of header issues using a RENAME Fields command with a Mapping table:

Header:
FIRST 1 LOAD @1:n as First_Line
FROM SalesProducts.csv
(fix, codepage is 1252);
Map_Fields:
MAPPING LOAD Field1, if(Field2=Previous(Field2), Field2 & '_2nd', Field2) as Field2;
LOAD '@' & RecNo() as Field1, Field2;
LOAD SubField(First_Line, ',') as Field2
Resident Header;
Drop Table Header;
SalesProducts:
LOAD @1, 
     @2, 
     @3, 
     @4, 
     @5
FROM SalesProducts.csv
(txt, codepage is 1252, no labels, delimiter is ',', msq, header is 1 lines);
RENAME Fields using Map_Fields;

- Ralf