topic Iterative Load on Resident Table in QlikView

Iterative Load on Resident Table

carlcimino — Thu, 22 Mar 2018 15:53:13 GMT

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;

Re: Iterative Load on Resident Table

olivierrobin — Thu, 22 Mar 2018 15:55:36 GMT

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

Re: Iterative Load on Resident Table

carlcimino — Thu, 22 Mar 2018 16:20:34 GMT

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