Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
martin_cevela
Contributor III
Contributor III

ApplyMap not working while concatenate

Hi to all,

I have a problem with a simple ApplyMap statement. It is not working properly or rather it is not able to do a match and all values are Null.

I have the same script for the Full load scenario and the script works. The only difference is that the Incremental load scenario is Concatenating the new retrieved data to the previously stored one. The QVD as well as SQL source has the LicenseTypeKey and/or LicenseTypeCode values in (checked). Thanks for ideas...

//Incremental load scenario

MAP_LicenseType:

Add Mapping LOAD

LicenseTypeKey,

LicenseTypeCode

FROM $(sG.SourceDir_DIM)GL_DIM_LicenseType.qvd (qvd);

Concatenate(updserver_d)

LOAD

'UP' as FactTypeId,

DateKey &'|'& 'UP' as LinkId,

PlatformKey,

ProductVersionKey,

ProductLanguageKey, CrackStatusKey,

CountryKey,

LicenseTypeKey,

ApplyMap('MAP_LicenseType',LicenseTypeKey,Null()) as LicenseTypeCode,

ProductSKey,

SharepointServerRoleKey,

LotusDominoServerRoleKey,

KerioConnectServerRoleKey,

KerioControlServerRoleKey,

MSExchangeServerRoleKey,

DateKey,

COUNT as #COUNT;

SQL SELECT ...;

//Full load scenario

DIM_LicenseType_FR:

Add Mapping LOAD

LicenseTypeKey,

LicenseTypeCode

FROM $(sG.SourceDir_DIM)GL_DIM_LicenseType.qvd (qvd);

/*updserver_d.qvd Full Reload Start*/

updserver_d:

LOAD

'UP' as FactTypeId,

DateKey &'|'& 'UP' as LinkId,

PlatformKey,

ProductVersionKey,

ProductLanguageKey, CrackStatusKey,

CountryKey,

LicenseTypeKey,

ApplyMap ('DIM_LicenseType_FR',LicenseTypeKey,Null()) as LicenseTypeCode,

ProductSKey

       ,SharepointServerRoleKey

      ,LotusDominoServerRoleKey

      ,KerioConnectServerRoleKey

      ,KerioControlServerRoleKey

      ,MSExchangeServerRoleKey

,DateKey

,COUNT as #COUNT;

SQL SELECT *...;

2 Replies
sunny_talwar

Is the above script part of a Partial Reload? If it is, you might need to add the keyword 'ADD' next to your table which you are concatenating.

sunny_talwar

Or may be you don't need Add here:

MAP_LicenseType:

Add Mapping LOAD

LicenseTypeKey,

LicenseTypeCode

FROM $(sG.SourceDir_DIM)GL_DIM_LicenseType.qvd (qvd);