How to get possible values from the script

[slondono]

Hi guys.

I have an excel with 2 fields, something like this:

Region      SubRegion

1                    10

1                     12

1                     8

2                    6

2                    2

3                    5

3                     20

I need a way from script, to get the subregions. I mean something like this

vRegion1 = "10,12,8"

Any idea?

[vikramv]

Try this.....

===================

Tab1:

Load * Inline

[

Region,  SubRegion

1 ,      10

1 ,                    12

1 ,                    8

2  ,                  6

2  ,                  2

3  ,                  5

3   ,                  20

];

Tab2:

NoConcatenate

Load Region , Concat(SubRegion , ',') as vRegion1 Resident Tab1 Group by Region;

Drop Table Tab1;

[sunny_talwar]

May be something like this:

LOAD Region,

           Concat(Sub-Region, ', ') as ConcatList

Resident Table

Where Region = 1;

Let vRegion1 = Peek('ConcatList');