topic Re: Does QV able to read Any.do export list ? in QlikView

Does QV able to read Any.do export list ?

paulyeo11 — Thu, 25 Feb 2016 03:52:10 GMT

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

Re: Does QV able to read Any.do export list ?

paulyeo11 — Thu, 25 Feb 2016 03:52:53 GMT

my Raw Data Txt file

Re: Does QV able to read Any.do export list ?

marcus_sommer — Thu, 25 Feb 2016 06:27:33 GMT

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

- Marcus

Re: Does QV able to read Any.do export list ?

settu_periasamy — Thu, 25 Feb 2016 06:55:17 GMT

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

Re: Does QV able to read Any.do export list ?

paulyeo11 — Thu, 25 Feb 2016 09:16:12 GMT

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

Re: Does QV able to read Any.do export list ?

settu_periasamy — Thu, 25 Feb 2016 09:18:26 GMT

Hi Paul,

Just Add RecNo(), in the script..

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

Re: Does QV able to read Any.do export list ?

paulyeo11 — Thu, 25 Feb 2016 09:25:42 GMT

Thank you very much.

Re: Does QV able to read Any.do export list ?

paulyeo11 — Thu, 25 Feb 2016 09:27:14 GMT

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

Re: Does QV able to read Any.do export list ?

tamilarasu — Fri, 26 Feb 2016 06:13:36 GMT

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