Iterative Load on Resident Table

[carlcimino]

I have  a table that represents 1 month of data.  I'd like to reload it so I have 12 months.  Each one of the sets should have a month indicator (1-12).  How does one accomplish that?  My resident table name is Goals and the columns are listed below.

load

LOB,

PRODUCER_NUM_7_DIGIT,

SUB_PRODUCER_NUM,

ACE_PROD_NUMBER,

GOALNBPREM,

GOALQUOTEPREM,

NB_IND,

DATATYPE

Resident Goals;

[olivierrobin · Accepted solution]

hello,

try this

for i=1 to 12

table:

load

LOB,

PRODUCER_NUM_7_DIGIT,

SUB_PRODUCER_NUM,

ACE_PROD_NUMBER,

GOALNBPREM,

GOALQUOTEPREM,

NB_IND,

DATATYPE,

'$(i)' as month_indicator

Resident Goals;

next i

[carlcimino]

Hi Oliver.  Thanks for the quick response.  Worked like a charm!