5 Replies Latest reply on Aug 30, 2016 12:45 PM by Erin Gehn

# Data Blending on UnEqual Fields

Hello~

I have two data sources.

One data source has a field of sequences.

The other data source has a field of numbers that correspond (one to one) to the sequences of data source 1.

The digits of the sequences in data source 1 do not match the digits of the numbers in data source 2. BUT one sequence in data source 1 is always paired with a corresponding number in data source 2.

Is there a way to blend these two data sources by this one to one relationship of the sequences in data source 1 to the numbers in data source 2??

For an example: In the Superstore Standard Dataset, let's say that office furniture all have a unique product ID and that product ID isn't specifically defined within that workbook. Another workbook houses some additional product statistics based on that product ID.  So, how can we link each specific office furniture product with its product ID to find the additional statistics for an office chair?

Please let me know if you have any questions.

I appreciate any suggestions or feedback.

• ###### 1. Re: Data Blending on UnEqual Fields

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.)

1 of 1 people found this helpful
• ###### 2. Re: Data Blending on UnEqual Fields

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.

• ###### 3. Re: Data Blending on UnEqual Fields

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?

• ###### 4. Re: Data Blending on UnEqual Fields

You would make the excel table the primary data source, and blend each of the actual data sources as secondary sources.

• ###### 5. Re: Data Blending on UnEqual Fields

Kk. Got it!

Thank you for your help!