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

Does QV able to read Any.do export list ?

Hi All

I have export my task list from Any.do app , my question is how to make use of QV to read the raw data ? in my next posting i will post the raw data text file.

Paul

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Hi Paul,

Just Add RecNo(), in the script..

Like

Directory;
Any_Do_App:
LOAD @1 as Any_Do_App,

     RecNo() as RowNumber
FROM
[File 25-2-16, 10 47 09 - Copy.txt]
(
txt, utf8, no labels, delimiter is '\t', msq);

View solution in original post

8 Replies
paulyeo11
Master
Master
Author

my Raw Data Txt file

marcus_sommer

The data seems rather unstructured but they could be loaded - you will need some logic to make sense of them.

- Marcus

settu_periasamy
Master III
Master III

Hi Paul,

I think the below one will give the required result. Just I load the file Delimiter as Tab using the Transformation Wizard.

Directory;
Any_Do_App:
LOAD @1 as Any_Do_App
FROM
[File 25-2-16, 10 47 09 - Copy.txt]
(
txt, utf8, no labels, delimiter is '\t', msq);


Capture.JPG

paulyeo11
Master
Master
Author

Hi Settu

Thank

Any idea how can i list all the task and count number of row ? so i know how many row in my table ?

Paul

settu_periasamy
Master III
Master III

Hi Paul,

Just Add RecNo(), in the script..

Like

Directory;
Any_Do_App:
LOAD @1 as Any_Do_App,

     RecNo() as RowNumber
FROM
[File 25-2-16, 10 47 09 - Copy.txt]
(
txt, utf8, no labels, delimiter is '\t', msq);

paulyeo11
Master
Master
Author

Thank you very much.

paulyeo11
Master
Master
Author

Hi Macrus

You are right , the table missing one dimension,

look like the dimension missing. for example task on urgent have 50 task,

So unable to make analysis.

Paul

tamilarasu
Champion
Champion

Would you mind to close this thread by marking Correct or Helpful answers.!!