ApplyMap not working as expected

arngue — Sat, 16 Nov 2024 17:49:05 GMT

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?

Re: ApplyMap not working as expected

agigliotti — Tue, 17 Nov 2020 09:45:00 GMT

Hi @arngue ,

Maybe you have to use single quote with ApplyMap ex. ApplyMap('TTN_TIP', TTN_TIP) as [Tipo]

Best Regards
Andrea

Re: ApplyMap not working as expected

MayilVahanan — Tue, 17 Nov 2020 09:48:49 GMT

Hi @arngue

ApplyMap('TTN_TIP', TTN_TIP)

<-- Applymap will use table name with single quotes. "Double Quotes" indicates the field Name.

Re: ApplyMap not working as expected

arngue — Tue, 17 Nov 2020 09:49:44 GMT

I dunno why this happens only sometimes

topic Re: ApplyMap not working as expected in App Development

ApplyMap not working as expected

Re: ApplyMap not working as expected

Re: ApplyMap not working as expected

Re: ApplyMap not working as expected