How to model this scenario

52 Views

Dear Experts,

I have requirement where in certain data is in infoset and need to join one DSO to that and the only common data will be one characterstics Zdoctor, how to model this

Below is the model data i am giving along with desired output.

Infoset

giving the below characterstics and output

Zdoctor, Zsalesman, Zdate, zjoint, zjointremarks, zL1, Zl2,

100 Daniel 10-01-2009 Yes Ok 14 15----this row is connecting to the ods-1's two rows

101 Daniel 11-01-2009 no cancel 14 15

102 Daniel 12-01-2009 no Probability 14 15

ODS-1

Zdoctor, Zsalesman, Zdate, zcategory, zcat_remarks, zbrand,

100 john 09-01-2009 12 Yes SPL

100 Sam 09-01-2009 13 No SPL

Need to add the below ODS-1 data to the above infoset side by side only thing

common between these two will be zdoctor characterstic.

The output should be

Zdoctor, Zsalesman, Zdate, zjoint, zjointremarks, zL1, Zl2, Zsalesman, Zdate, zcategory, zcat_remarks, zbrand,

100 Daniel 10-01-2009 ~~-yes- Ok~~ --

14 15 john 09-01-2009 12 Yes SPL

100 Daniel 10-01-2009 Yes Ok 14 15 Sam 09-01-2009 13 No SPL

Thanks and Regards

Neel