topic default value for missing data in parent table on LOAD in QlikView

default value for missing data in parent table on LOAD

Fri, 14 Nov 2014 11:48:19 GMT

Dear All,

i have two tables 1 ) ScripMaster and 2) ScripDetail

ScripMaster have two fields ScripCode (PK) , scripType;

ScripDetail have ScripCode(FK) and ScripId, Count;

some time what happen there are some ScripCode which is there in ScripDetail table but not in ScripMaster, So due to this i am not able to know the ScripType. In this type of condition i want to assign a default ScripType to that particular ScripCode.

Kindly help how can i do while loading the data.

Re: default value for missing data in parent table on LOAD

Anonymous — Fri, 14 Nov 2014 11:58:45 GMT

ScripMasterMap:

mapping load

ScripCode ,

scripType;

from .....................

;

ScripDetail Map:

mapping load

applymap('ScripMasterMap',ScripCode,'Your Default')

ScripCode ,

ScripId,

Count

from .....................

;