Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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
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
Hi Oliver. Thanks for the quick response. Worked like a charm!