on 07-29-2018 7:29 AM - last edited on 02-04-2024 4:47 AM by postmig_api_4
I am pulling data from 2 data providers and the common Keys between the two are Policy Number and Effective Date. I need to get the Policy Status from the 2nd provider. but the issue is that in same Policy Number can have different Effective dates and different Policy Statuses. When I create a detail object and link it to the Policy Number (Merged dimension), I get a Multi-value error. If I were to choose the Policy Status based on PolicyNumber+EffectiveDate combination, I would have got just one record.
Need your help in this matter..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.