topic Issue in importing CSV file in Qlikview application in QlikView

Issue in importing CSV file in Qlikview application

Tue, 03 Apr 2012 11:08:58 GMT

Hi,

Pleasefind attached one CSV file format.

Can any one help me to load this CSV file in Qlikview application.

Issue is QV appilcation not loading the CSV file due to some column dont have header name(field name) but it has data.

Thanks,

Antony

Issue in importing CSV file in Qlikview application

Tue, 03 Apr 2012 11:37:11 GMT

Can any one help me to solve the above Query.

Issue in importing CSV file in Qlikview application

vijay_iitkgp — Tue, 03 Apr 2012 12:11:36 GMT

Hi,

Qlikview doesnot understand the space as field header. Instead of using Embeded Label use explicit label and define your labels after loading.

Hope this will help

Issue in importing CSV file in Qlikview application

Tue, 03 Apr 2012 12:25:50 GMT

If i have more than 100 fields then how can i rename each & every fields.

is there any other option to rename blank header column.

Re: Issue in importing CSV file in Qlikview application

Tue, 03 Apr 2012 12:27:38 GMT

Hi Antony,

Please find the attched qvw, hope this will help you.

Use Explict label and remove the header.

Issue in importing CSV file in Qlikview application

Tue, 03 Apr 2012 12:36:57 GMT

Hi Sri,

If i have less fields then not a problem to do rename but i have more than 100 fields in each CSV file with some blank header name.

Issue in importing CSV file in Qlikview application

sivarajs — Tue, 03 Apr 2012 13:02:16 GMT

Its better to suggest them to add field name in log itself

Sivaraj S

Issue in importing CSV file in Qlikview application

Tue, 03 Apr 2012 13:20:50 GMT

Hi Antony,

Please check, Is there any possibilty in Excel to fill the empty cells to string.

Regards,

Siri

Issue in importing CSV file in Qlikview application

flipside — Tue, 03 Apr 2012 14:07:19 GMT

Hi Antony,

Use this script to rename your missing fields with MissingField1, MissingField2 etc. if too many to rename. Ensure you have a RowNo() in your data table to identify the top row which needs deleting.

Data:
LOAD
RowNo() AS Hdr,
@1, ...

FROM
[test_customer.csv]
(txt, codepage is 1252, no labels, delimiter is ',', msq);

let fldCount = NoOfFields('Data');

let fldMissing = 1;

For c = 2 to fldCount // ignore col 1 as the link

let fldName = FieldName('$(c)','Data');
let fldValue = FieldValue('$(fldName)',1);

if fldValue = '' then
let fldValue = 'MissingField' & '$(fldMissing)';
let fldMissing = fldMissing +1;
end if;

RENAME FIELD '$(fldName)' to '$(fldValue)';

Next c;

right keep (Data)
load Hdr resident Data where Hdr <>1;

DROP FIELD Hdr;

flipside

Issue in importing CSV file in Qlikview application

Tue, 24 Apr 2012 03:54:00 GMT

Hi flipside,

Just wondering why you need a RowNo() as the first field. I deleted it and it works fine as well. Could you explain me that? Thank you.

Regards,

Xue Bin

Issue in importing CSV file in Qlikview application

suniljain — Tue, 24 Apr 2012 05:42:14 GMT

you can eliminare RowNo() field if you donot required. its for physical indexing of records.

Issue in importing CSV file in Qlikview application

flipside — Thu, 26 Apr 2012 18:30:17 GMT

I've used the RowNo() function to mark the top row of data so it can be removed later on (there are various ways to do this, but I have used the 'right keep ... where Hdr <> 1'). Bear in mind you are loading the original headers as text, then inspecting them one by one and renaming based on whether the value is there or empty.

flipside

Issue in importing CSV file in Qlikview application

Fri, 27 Apr 2012 03:03:29 GMT

I got it. Thanks flipside:)

Xue Bin