Data Transformation - Remove garbage values and import proper fields

[engishfaque]

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]

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]

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]

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 · Accepted solution]

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