1 of 1 people found this helpful
You can blend on calc fields. They don't have to be the native data source fields.
If you could have a calc field in each source derive an equivalence, then you can blend on that.
So a broad example would be a calc in each Source doing an UPPER on the field you want to blend on so that case-sensitivity is removed.
But as far as I know, you will only get a blend if you have a value from source 1 exactly match up with a value from source 2. I have never seen something like a CONTAINS working in a blend. (Thus, blending 'North Carolina' with 'Carolina', for example.)
Okay. I'll have to dig deeper into the data to see if the two fields have any algorithmic variance to match the other.
Otherwise, all I can think to do is create a CASE WHEN statement. The issue in doing this is that I would have to go back and add to the joining calc field if ever a new relationship (new "office furniture/product ID") populated in the background.
Do you think I could just make an excel doc of the two fields with relationship and then blend the two data sources to the excel data source?
Is double blending allowed ---for 3 data sources?
You would make the excel table the primary data source, and blend each of the actual data sources as secondary sources.
Kk. Got it!
Thank you for your help!