topic Inline Load within Resident Load in QlikView

Inline Load within Resident Load

prees959 — Tue, 05 Sep 2017 19:35:51 GMT

Hi,

I am creating a number of QVDs within a loop and depending on which loop the current 'pass' is I want to write a value into the qvd.

For example.

DO WHILE counter < 3

TIMES:

load

[KEY],

if(counter =0 ,'AM',

if(counter =1 ,'PM',

if(counter =2 ,'ALLDAY'))) as TIME_TYPE,

START_DATE,

END_DATE

Resident LOAD1;

left join

load

STATUS_ID,

NAME,

STATUS_VALUE,

[KEY]

RESIDENT [STATUS];

counter=counter+1;

STORE TIMES INTO....;

DROP TABLE TIMES;

LOOP;

So, depending on what part of the loop the script is in, I want to reference this in the table I am creating.

I have tried the above If Statement - but I am getting an error.

Cananyone advise please?

Thanks,

Phil

Re: Inline Load within Resident Load

sunny_talwar — Tue, 05 Sep 2017 19:42:45 GMT

Couple of things...

1) Do you initiate your counter variable?

LET counter = 0

2) Use it like this may be

Pick($(counter) + 1 , 'AM', 'PM', 'ALLDAY') as TIME_TYPE

Re: Inline Load within Resident Load

maxgro — Tue, 05 Sep 2017 20:56:49 GMT

without if

for each timetype in 'AM', 'PM', 'ALLDAY'

TIMES:

load

[KEY],

'$(timetype)' as TIME_TYPE,

START_DATE,

END_DATE

Resident LOAD1;

left join

......

next

Re: Inline Load within Resident Load

prees959 — Wed, 06 Sep 2017 07:50:56 GMT

Perfect thanks!

Phil