5 Replies Latest reply on Oct 12, 2016 9:58 AM by David Li

    How to combine data by join or blend when fields have different values?

    David Gould

      I am trying to pull data from two sources, matching them based upon a campaign name value. The issue is that while I can join them by linking their respective campaign fields, the values in each are formatted differently for the same campaign.

       

      For example, Source A has the campaign value as "My Campaign Name" and Source B has it as "campaign_123". So even though it's the same campaign, it can't match the data because it doesn't see the values as equivalent. Is there a way to map field data values so Tableau understands them as equivalent? If I just needed to pair one mismatched set of values this would be easier, but there are many such campaigns I need to pair off so am look for a solution that can scale.

       

      Any help would be appreciated!