8 Replies Latest reply on May 30, 2016 1:44 AM by Manuel Gruber

# Matching "Tier Levels" from two different sources

Hey Guys,

I´m struggling to figure out how to deal with this problem.

So I´m trying to accomplish the thing I did in this simple Excel example.

I have two Tables and im trying to get the output below. I want to split up the Tier Level(A) into all possible Tier Level (B) as they may differ from Tier Level(A).

The output table shows how many times a Tier Level (A) is Tier 1 at Tier Level(B) and so on.

I hope my problem is clear.

I can´t post my workbook, because of confidential information.

Thanks a lot!

EDIT: The two tables are from 2 different data sources.

• ###### 1. Re: Matching "Tier Levels" from two different sources

Hi Manuel,

Please find the attached solution (Tableau Version 9.2), what I have done is blended based on the common data columns between two difference data source by going to Edit Relationship menu option and linked the two columns so based on the values between two data sources it will show the output.

• ###### 2. Re: Matching "Tier Levels" from two different sources

Okay it´s a little more complex.

The both lists also contain values (names) which are not in the other list. And some are values are NULL.

I guess i need a calculated field that first searches for nameA = nameB and then compares the Tier Level.

I did put in the number of records as you did. But the numbers are the total numbers of Null, Tier 1, etc. in ListA.

• ###### 3. Re: Matching "Tier Levels" from two different sources

Any ideas?!

• ###### 4. Re: Matching "Tier Levels" from two different sources

Hi Manuel,

Could you please share the workbook with some dummy data as you shown in the excel example, so it will help.

• ###### 5. Re: Matching "Tier Levels" from two different sources

Hi Manuel,

If possible please share the workbook. Chances of getting your problem solved will increase,

Thanks and Regards,

Ashish Chaudhari

• ###### 6. Re: Matching "Tier Levels" from two different sources

How do I attach the workbook?

Sorry I´m pretty new to this forum.

• ###### 7. Re: Matching "Tier Levels" from two different sources

This will show options to attach file.

-Ashish

• ###### 8. Re: Matching "Tier Levels" from two different sources

Okay thanks. I didn´t see the attach thing in the bottom right corner.

This sample data, throws the same "error" message as the real data.