Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
julioarriaga
Creator II
Creator 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);

1 Solution

Accepted Solutions
sunny_talwar

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
sunny_talwar

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