For Loop

[#1]

Hi All !

I need some help...

I have a table ...

in this table i have a field as 'serialNo.'  whose values are as  101,201,301,401...nd so on...

Nw i want to generate a series for each of the above value.

Like:

For Value : 101

                  102

                  103

                  104

                  105

                  106

                  107

                   .

                   .

                   .

                  110

Similarly for Value 201...

[gussfish]

Here's one way to do it:

data:

load *

inline [serialNo

;

extras:

load *

inline [extra

;

crossjoin:

load serialNo as ser

Resident data;

outer join

load extra as X

Resident extras;

extendedlist:

load ser+X as series

resident crossjoin;

drop Tables crossjoin, extras;

[#3]

Thnx For the Reply...but I didn't get u...

anyways i have found a solution....

Thnx again for ur help.