Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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);
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.
Hi Mr. Paul,
Can you share those files?
Regards,
Sokkorn