Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

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

8 Replies
paulyeo11
Valued Contributor II

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

my Raw Data Txt file

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

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 ?

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
Valued Contributor II

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

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 ?

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
Valued Contributor II

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

Thank you very much.

paulyeo11
Valued Contributor II

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

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 ?

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

Community Browser