topic Re: Do while iterno() issue in QlikView

Do while iterno() issue

rakesh_kumar — Thu, 14 Jan 2016 09:02:08 GMT

Hi All,

I have a requirement where I have 10 user IDs, each having more than 400 text, I would like to load only 2000 records into 5 QVDs for first 5 user IDs, like 400 for each user and stop there. But the problem is the code was not stopping at 2000 records (5 users) and loading 400 records for each remaining 5 users, creating 10 QVDs and still running. Please let me know how I can resolve this?

Re: Do while iterno() issue

jagan — Thu, 14 Jan 2016 09:10:10 GMT

Hi,

Instead of IterNo() you can vLoopNumber variable like below, Iterno() works only in Load statement

LET vLoopNumber = 1;

Do while vLoopNumber < 2000

Let vLoopVariable = peek('LoopVariable',vLoopNumber-1,'LoopVariables');

Twitter_Table:

First 400 LOAD

id as UserTimelineid,

created_at as UserTimelinecreated_at,

text as UserTimelinetext,

source as UserTimelinesource

FROM

[http://localhost:5555/QVSource/TwitterConnectorV2/?table=UserTimeline&userName=$(vLoopVariable)&appId=]

(qvx);

STORE Twitter_Table into 'QVDs\QVD_$(vLoopVariable).qvd';

DROP Table Twitter_Table;

vLoopNumber = vLoopNumber+1;

LOOP

Regards,

Jagan.

Re: Do while iterno() issue

rakesh_kumar — Thu, 14 Jan 2016 10:03:00 GMT

Hi Jagan,

Thanks for the reply.

Sorry it didn't worked. Your code is working the same way as my original code.

Is there any other way to resolve this issue?

Thanks

Re: Do while iterno() issue

PradeepReddy — Thu, 14 Jan 2016 11:06:41 GMT

try by changing the do while condition

"Do while IterNo() < 2000" to 'Do while IterNo() <=5'

Edit:

If I understand correctly, you want to retrieve the first 400 tweets by the user and store them in the QVD. If so, you required 5 iterations only.

Re: Do while iterno() issue

jagan — Fri, 15 Jan 2016 00:10:55 GMT

HI,

Instead of do while use while

LET vLoopNumber = 1;

DO while vLoopNumber < 2000

Let vLoopVariable = peek('LoopVariable',vLoopNumber-1,'LoopVariables');

Twitter_Table:

First 400 LOAD

id as UserTimelineid,

created_at as UserTimelinecreated_at,

text as UserTimelinetext,

source as UserTimelinesource

FROM

[http://localhost:5555/QVSource/TwitterConnectorV2/?table=UserTimeline&userName=$(vLoopVariable)&appId=]

(qvx);

STORE Twitter_Table into 'QVDs\QVD_$(vLoopVariable).qvd';

DROP Table Twitter_Table;

LET vLoopNumber = vLoopNumber+1;

LOOP

This should work, if not try debugging where you are getting issue.

Regards,

Jagan.