Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

default value for missing data in parent table on LOAD

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

ScripMasterMap:

mapping load

ScripCode ,

scripType;

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

;

ScripDetail Map:

mapping load

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

ScripCode ,

ScripId,

Count

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

;

View solution in original post

1 Reply
Anonymous
Not applicable
Author

ScripMasterMap:

mapping load

ScripCode ,

scripType;

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

;

ScripDetail Map:

mapping load

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

ScripCode ,

ScripId,

Count

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

;