Autogenerate

[#1]

Hi ,

I got a requirement in which i need to generate rows dynamically.

if v_temp=6

Code:

for j=1 to '$(v_temp)'

New_Month_Gen:

load

1 as temp

AutoGenerate '$(v_temp)'

;

Resul set should be :

temp

1

2

3

4

5

6

Please tell a solution.

Thanks,

Azim

[#2]

This works:

SET

v_temp=6;



for j=1 to '$(v_temp)'



New_Month_Gen:

load

$(j) as temp

AutoGenerate (1);



next j

[jagan]

Hi,

Try like this

let v_temp = 6;

Temp:

load

RowNo() AS temp

AutoGenerate '$(v_temp)';

Hope this helps you.

Regards,

Jagan.