Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

1 Solution

Accepted Solutions
Sokkorn
Master
Master

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

View solution in original post

4 Replies
Sokkorn
Master
Master

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
Partner - Creator III
Partner - Creator III

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);

Not applicable
Author

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
Master
Master

Hi Mr. Paul,

Can you share those files?

Regards,

Sokkorn