topic Re: Mapping after moving from REST CONNECTION to DATA GATEWAY in Move to Qlik Cloud Analytics

Mapping after moving from REST CONNECTION to DATA GATEWAY

davenyrfajutag00 — Tue, 27 Jan 2026 10:45:26 GMT

Good morning everyone,

I am having some problems with Mapping tables after transfering my connection from REST connection to DATA GATEWAY.

I have just checked the script and everything seems to be correct.

Map1:

Mapping

LOAD

TEXT(ID_AZIENDA) & TEXT(ID_LINEA_PROD),

DESCRIZIONE AS A_DESCR_LINEA_PRODOTTO;

SELECT

"ID_AZIENDA",

"ID_LINEA_PROD",

"DESCRIZIONE"

FROM PANTH01.THIP.LINEE_PRODOTTO

;

Articoli:

LOAD

TEXT(ID_ARTICOLO) AS ID_ARTICOLO,

Text(ID_AZIENDA) &'_'& Text(ID_ARTICOLO) AS ARTICOLI_KEY,

ApplyMap('Map1', TEXT(ID_AZIENDA) & TEXT(R_LINEA_PROD),'_') AS A_LINEA_PROD

;

SELECT

"ID_AZIENDA",

"ID_ARTICOLO",

"R_LINEA_PROD"

FROM PANTH01.THIP.ARTICOLI;

Can you help me please?

Thank you in advance

Re: Mapping after moving from REST CONNECTION to DATA GATEWAY

Albert_Candelario — Fri, 07 Jul 2023 09:17:23 GMT

Hello @davenyrfajutag00 ,

Are you using the Data Gateway Direct Access or Data Movement?

Cheers,

Albert

Re: Mapping after moving from REST CONNECTION to DATA GATEWAY

davenyrfajutag00 — Fri, 07 Jul 2023 09:19:11 GMT

I'm using Data Gateway Direct Access, it seems like it doesn't recognize any APPLY MAP

Re: Mapping after moving from REST CONNECTION to DATA GATEWAY

Albert_Candelario — Tue, 11 Jul 2023 11:45:47 GMT

Hello @davenyrfajutag00,

I think you has contacted us on this on a Support case and is now resolved. The issue was on your code logic, so not a product issue on Data Gateway per se.

Cheers,

Albert