For loop in Load script

[Anonymous]

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

[Gysbert_Wassenaar]

MyTable:

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

FROM ....

WHILE IterNo() <6;

[Miguel_Angel_Baeyens]

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

[maxgro · Accepted solution]

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;

[Anonymous]

Hi Miguel

I appreciate your solution, work nicely

Thanks

[Anonymous]

Hi Massimo

This is working nice.

I appreciate your effort

Thanks