I just added to script loader a line, this:
[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"
How can I fix this? It could be fix?
