Can QV read finger print data file which end with dat ?

[#1]

Hi All

I just purchase a finger print device , each staff when come in office , they must use their finger to let the machine record when their arrive at office , and the device provide me 3 data file . and the data file will be copy to computer , and the finger print device provide the software which able to convert the 3 row data file into 1 excel file.

my question is can QV directly read the raw data file ? So that user don't need to convert it into excel file.

enclosed one of the data file for your ref.

Paul

[Sokkorn · Accepted solution]

Hi Mr. Paul,

Just download your attached file and test with my QlikView. It simple

[Att]:

LOAD

     @1,

     @2,

     @3,

     @4,

     @5,

     @6

FROM

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

Can you tell me which is the problem you faced?

Regards,

Sokkorn

[jonasheisterkam]

It is a csv-file wth tab as seperator. You can load it with.

LOAD @1,

     @2,

     @3,

     @4,

     @5,

     @6

FROM

[1_attlog finger print]

(txt, codepage is 1252, no labels, delimiter is '\t', msq);

[#4]

Yes it work fine. many thank for both of your help. But i have 2 more file which is not able to load in to QV.

[Sokkorn]

Hi Mr. Paul,

Can you share those files?

Regards,

Sokkorn