topic Re: For loop in Load script in QlikView

For loop in Load script

Anonymous — Mon, 09 Mar 2015 18:34:13 GMT

I have data set as under

I want the same result five times like

REGION STATE SALES SCENARIO

EAST-1 NY 10 1

EAST-1 NJ 5 1

EAST-1 MD 3 1

WEST-1 NY 7 1

WEST-1 NY 15 1

Same result for five times instead 1, I need 2,3, 4 & 5

Sample QV attached...

Thanks

Re: For loop in Load script

Gysbert_Wassenaar — Mon, 09 Mar 2015 18:40:50 GMT

MyTable:

LOAD REGION, STATE, SALES, IterNo() as SCENARIO

FROM ....

WHILE IterNo() <6;

Re: For loop in Load script

Miguel_Angel_Baeyens — Mon, 09 Mar 2015 18:41:52 GMT

Hi Satish,

Use

Table:
LOAD *,
     1 AS SCENARIO
FROM File.qvd (qvd);

FOR i = 2 TO 5

CONCATENATE (Table)
LOAD *,
     $(i) AS SCENARIO
FROM File.qvd (qvd);

LOOP

Miguel

Re: For loop in Load script

maxgro — Mon, 09 Mar 2015 18:44:21 GMT

another one

Sales:

LOAD * INLINE [

REGION, STATE, SALES

EAST, NY, 10

EAST, NJ, 5

EAST, MD, 3

WEST, CA, 7

WEST, AR, 15

];

left join (Sales)

load rowno() as SCENARIO AutoGenerate 5;

Re: For loop in Load script

Anonymous — Mon, 09 Mar 2015 19:09:27 GMT

Hi Miguel

I appreciate your solution, work nicely

Thanks

Re: For loop in Load script

Anonymous — Mon, 09 Mar 2015 19:10:08 GMT

Hi Massimo

This is working nice.

I appreciate your effort

Thanks