Hi Guys,
Anyone can explain me why this code isn't working, it's getting me map_id not found error.
LET vL.TableName = 'Notas_Tramites_Tareas';
LET vL.FromQvdName = 'TTN';
LET vL.StoreQvdName = 'Notas_Tramites_Tareas';
LET vL.before = Now();
TTN_TIP:
Mapping Load * Inline [
TTN_TIP, val
A, Automatica
M, Manual
];
$(vL.TableName):
LOAD
"TTN_ID" as [ID_Nota],
"TTN_TRT" as [ID_TramiteTarea],
"TTN_USC" as [ID_Usuario_Creador],
"TTN_FEC" as [Fecha],
"TTN_TIT" as [Nota],
"TTN_DES" as [Descripcion],
ApplyMap("TTN_TIP", TTN_TIP) as [Tipo],
"TTN_TIP" as [Codigo Tipo]
From $(vL.From_QVD_PATH)/$(vL.From_Layer)/$(vL.FromQvdName).qvd(qvd);
Store $(vL.TableName) into $(vL.Store_QVD_PATH)/$(vL.Store_Layer)/$(vL.StoreQvdName).qvd (qvd);
LET vL.after = Now();
LET vL.TableNumber = $(vL.TableNumber) + 1;
LET vL.TableName_$(vL.TableNumber) = '$(vL.TableName)';
LET vL.NoOfRows_$(vL.TableNumber) = NoOfRows('$(vL.TableName)');
LET vL.NoOfFields_$(vL.TableNumber) = NoOfFields('$(vL.TableName)');
LET vL.TableTime_$(vL.TableNumber) = Interval(Timestamp('$(vL.after)') - timestamp('$(vL.before)'),'hh:mm:ss');
Drop table $(vL.TableName);
I use other ApplyMaps in prevoius files, could be a number maximum of mapped tables? is there a way to drop thoose?
