We have a situation where we need to build a relationship between two Data Sources (DS), where there are 2 keys on the 2nd source to look at. We cannot create the correct calculation when building the relationship in the Data Source. Does anyone have any ideas on how to do this please?
Here is what we are looking to do.... DS-A ID field value can be found in either the DS-B ID1 or DS-B ID2. If it finds a match in ID1 that is OK, if not then look at ID2
DS-A->ID = (DS-B->ID1 OR DS-B->ID2)
I think you would likely need to do Custom SQL for this. Alternatively, it might be possible with Project Maestro (now in Beta) to do something like, create a calculation to combine DS-B ID1 and DS-B ID2, then join on that calculation + DS-A ID.