Create a mapping table joining two mapping loads from 2 qvds

julioarriaga — Wed, 01 Aug 2018 14:54:55 GMT

Is it possible and correct to create a mapping table joining two mapping loads from 2 qvds?

Thanks!

SociosPostuladosID:
MAPPING LOAD DISTINCT ID AS %Key_Vacante
FROM [$(pRuta)$(pDatosBaseHechos)$(Hechos)Vacantes.qvd] (QVD);

JOIN (SociosPostuladosID)
MAPPING LOAD DISTINCT ID_VACANTE AS %Key_Vacante
,EMPLID AS %Key_SocPostID
FROM [$(pRuta)$(pDatosBaseDim)RegistroCandidato.qvd] (QVD);

Re: Create a mapping table joining two mapping loads from 2 qvds

sunny_talwar — Wed, 01 Aug 2018 15:02:08 GMT

I don't think this is possible... may be join first and then create a mapping load within the resident load

SociosPostuladosID:

LOAD DISTINCT ID AS %Key_Vacante

FROM [$(pRuta)$(pDatosBaseHechos)$(Hechos)Vacantes.qvd] (QVD);

JOIN (SociosPostuladosID)

LOAD DISTINCT ID_VACANTE AS %Key_Vacante

,EMPLID AS %Key_SocPostID

FROM [$(pRuta)$(pDatosBaseDim)RegistroCandidato.qvd] (QVD);

MappingSociosPostuladosID:

MAPPING

LOAD *

Resident SociosPostuladosID;

DROP Table SociosPostuladosID;

topic Create a mapping table joining two mapping loads from 2 qvds in QlikView

Create a mapping table joining two mapping loads from 2 qvds

Re: Create a mapping table joining two mapping loads from 2 qvds