Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

julioarriaga
Contributor II

Create a mapping table joining two mapping loads from 2 qvds

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);

Tags (2)
1 Solution

Accepted Solutions
Highlighted

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

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;

View solution in original post

1 Reply
Highlighted

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

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;

View solution in original post