[SH_historico_1]: LOAD [ANOMES] AS [SH_historico_1.ANOMES], APPLYMAP( 'TIP_TARMapping', [TIP_TAR]) AS [SH_historico_1.TIP_TAR], [MARCA_RENEG] AS [SH_historico_1.MARCA_RENEG], [MONTO] AS [SH_historico_1.MONTO], [TRAMOMORA] AS [SH_historico_1.TRAMOMORA], [DIA_PAGO] AS [SH_historico_1.DIA_PAGO], [CASOS] AS [SH_historico_1.CASOS], [CANAL] AS [SH_historico_1.CANAL], [TRAMO_PAGO] AS [SH_historico_1.TRAMO_PAGO], [DIAS_AL_CIERRE] AS [SH_historico_1.DIAS_AL_CIERRE], [TIPO_MORA] AS [SH_historico_1.TIPO_MORA], [ANOMES]&[TIPO_MORA]&(APPLYMAP( 'TIP_TARMapping', [TIP_TAR])) AS [SH_historico_1.ANOMES-SH_historico_1.TIPO_MORA-SH_historico_1.TIP_TAR-ANO_MES-TramoMora_Bucket-TIPO_PRODUCTO], Makedate(Left([ANOMES],4),Right([ANOMES],2)) as Date; SQL SELECT "ANOMES", "TIP_TAR", "MARCA_RENEG", "MONTO", "TRAMOMORA", "DIA_PAGO", "CASOS", "CANAL", "TRAMO_PAGO", "DIAS_AL_CIERRE", "TIPO_MORA" FROM "DL_RG_ANALYTICS"."SH_historico_1";
I just added this line: Makedate(Left([ANOMES],4),Right([ANOMES],2)) as Date;
And now doesnt work data manager, it show that "Sync script"