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

    Data Blending on UnEqual Fields

    Erin Gehn

      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.