Mapping after moving from REST CONNECTION to DATA GATEWAY

[davenyrfajutag00]

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

[Albert_Candelario]

Hello  @davenyrfajutag00 ,

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

Cheers,

Albert

[davenyrfajutag00]

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

[Albert_Candelario · Accepted solution]

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