Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
my Raw Data Txt file
The data seems rather unstructured but they could be loaded - you will need some logic to make sense of them.
- Marcus
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);
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
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);
Thank you very much.
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
Would you mind to close this thread by marking Correct or Helpful answers.!!