Data Model

santharubban — Wed, 18 Mar 2015 14:13:14 GMT

Hi All,

I am facing a data model issues, there 2 different data sources in which one data source have structure of genealogy and other data source have its relative information. Now I want to join these 2 data source take details of each genealogy details, can anyone help on same. For reference I have attached the sample excel with 2 different data source and its output.

Re: Data Model

santharubban — Wed, 18 Mar 2015 14:50:29 GMT

Stages are nothing but Batching, for each stage I need to provide the relative data from the 2nd data sources without breaking genealogy structure. can any help me out on same.

Re: Data Model

Gysbert_Wassenaar — Wed, 18 Mar 2015 15:25:56 GMT

Something like this:

AST:

MAPPING LOAD BATCH, ACT_START_DATE FROM ....

AFT:

MAPPING LOAD BATCH, ACT_FINISH_DATE FROM ....

QRD:

MAPPING LOAD BATCH, QA_RELEASE_DATE FROM ....

LOAD

STAGE_1_BATCH

applymap('AST',STAGE_1_BATCH) AS STAGE_1_ACT_START_DATE

applymap('AFT',STAGE_1_BATCH) AS STAGE_1_ACT_FINISH_DATE

applymap('QRD',STAGE_1_BATCH) AS STAGE_1_QA_RELEASE_DATE

STAGE_2_BATCH

applymap('AST',STAGE_2_BATCH) AS STAGE_2_ACT_START_DATE

applymap('AFT',STAGE_2_BATCH) AS STAGE_2_ACT_FINISH_DATE

applymap('QRD',STAGE_2_BATCH) AS STAGE_2_QA_RELEASE_DATE

STAGE_3A_BATCH

applymap('AST',STAGE_3A_BATCH) AS STAGE_3A_ACT_START_DATE

applymap('AFT',STAGE_3A_BATCH) AS STAGE_3A_ACT_FINISH_DATE

applymap('QRD',STAGE_3A_BATCH) AS STAGE_3A_QA_RELEASE_DATE

STAGE_3B_BATCH

applymap('AST',STAGE_3B_BATCH) AS STAGE_3B_ACT_START_DATE

applymap('AFT',STAGE_3B_BATCH) AS STAGE_3B_ACT_FINISH_DATE

applymap('QRD',STAGE_3B_BATCH) AS STAGE_3B_QA_RELEASE_DATE

STAGE_4_BATCH

applymap('AST',STAGE_4_BATCH) AS STAGE_4_ACT_START_DATE

applymap('AFT',STAGE_4_BATCH) AS STAGE_4_ACT_FINISH_DATE

applymap('QRD',STAGE_4_BATCH) AS STAGE_4_QA_RELEASE_DATE

STAGE_STAGE_5_BATCH

applymap('AST',STAGE_STAGE_5_BATCH) AS STAGE_STAGE_5_ACT_START_DATE

applymap('AFT',STAGE_STAGE_5_BATCH) AS STAGE_STAGE_5_ACT_FINISH_DATE

applymap('QRD',STAGE_STAGE_5_BATCH) AS STAGE_STAGE_5_QA_RELEASE_DATE

FROM ...

topic Re: Data Model in QlikView

Data Model

Re: Data Model

Re: Data Model