Change Table name Dynamic

juan_patrick — Thu, 04 Jun 2015 14:45:41 GMT

Hi, I have this script:

FOR vReg = 0 TO NOOFROWS('INTERVALOS')-1

LET vMeses = PEEK('DIF', $(vReg),'INTERVALOS');

LET vFMIN = PEEK('FEMIN', $(vReg),'INTERVALOS');

LET vClave = PEEK('KEY', $(vReg),'INTERVALOS');

LET vNombreTabla = 'INTERVALOS_FULL_' & PEEK('ANIO', $(vReg),'INTERVALOS');

[$(vNombreTabla)]:

LOAD

'$(vClave)' AS %KEY_FECHA,

date(AddMonths('$(vFMIN)',recno()-1),'YYYYMM') AS AÑOMES

Autogenerate '$(vMeses)' + 1;

Next vReg;

where vNombreTabla is the table's name, but, I want to create some tables with the year, something like this:

INTERVALOS_FULL_2014

INTERVALOS_FULL_2015

The table name is INTERVALOS_FULL_ + YEAR

The problem is the script only create one table! (INTERVALOS_FULL_2001) and I know there are more years in the field.

Thanks!!

Re: Change Table name Dynamic

sunny_talwar — Thu, 04 Jun 2015 14:54:44 GMT

Try adding in NoConcatenate after the table name variable like this:

[$(vNombreTabla)]:

NoConcatenate

LOAD

'$(vClave)' AS %KEY_FECHA,

date(AddMonths('$(vFMIN)',recno()-1),'YYYYMM') AS AÑOMES

Autogenerate '$(vMeses)' + 1;

HTH

Best,

Sunny