Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
MyTable:
LOAD REGION, STATE, SALES, IterNo() as SCENARIO
FROM ....
WHILE IterNo() <6;
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
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;
Hi Miguel
I appreciate your solution, work nicely
Thanks
Hi Massimo
This is working nice.
I appreciate your effort
Thanks