topic Re: Data Transformation - Remove garbage values and import proper fields in QlikView

Data Transformation - Remove garbage values and import proper fields

engishfaque — Wed, 04 Mar 2015 22:55:26 GMT

Dear All,

I have a file, such as attached.

This file is my data source file, and I have to import in QlikView with applying appropriate transformation.

First seven rows are garbage values in attached document after that my fields name starts.

Now, I have to remove garbage values and import data with proper fields name. Such as illustrated in given below desired output.

Desired output feilds name:

[date/time], [settlement id], [order id], Name

Kind regards,

Ishfaque Ahmed

maxgro — Wed, 04 Mar 2015 23:16:49 GMT

table:

LOAD [date/time],

[settlement id],

type,

[order id],

Name

FROM

DataFile.txt

(txt, unicode, embedded labels, delimiter is '\t', msq, header is 7 lines);

engishfaque — Wed, 04 Mar 2015 23:52:19 GMT

Dear Massimo,

I'm facing an issue, please check attached.

Tbl:

LOAD [date/time],

[settlement id],

type,

[order id]

FROM

[..\Data Files\CSVs\Daily Sales File\DataFile.csv]

(txt, utf8, embedded labels, delimiter is '\t', msq, header is 7 lines);

Error:

Kind regards,

Ishfaque Ahmed

rwunderlich — Thu, 05 Mar 2015 00:00:16 GMT

You need "embedded labels". Use the Table files wizard to generate the correct statement. Set the header size to 7 lines in the wizard.

-Rob

engishfaque — Thu, 05 Mar 2015 00:10:30 GMT

Dear Rob,

My script is not working on the "header is 7 line", but my script is working correct on "header is 10 lines".

Kind regards,

Ishfaque Ahmed