- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Iterative Load on Resident Table
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;
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Oliver. Thanks for the quick response. Worked like a charm!