Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (17.6k points)

I am a newbie in tableau. I have two data sources, an excel file, and a connection database. I need to find a description ID in the excel file (table1) and paste it into the table database (table2).

Example:

The Excel file (table1):

+-------+---------------+----------------+

|  Id   | description1  | description2   |

+-------+---------------+----------------+

| 01:01 | soft          | install soft   |

| 12:04 | soft          | uninstall soft |

+-------+---------------+----------------+

The connected database (table2):

+-------+---------+------+

|  ID   |  group  | name |

+-------+---------+------+

| 01:01 | IT      | bob  |

| 12:04 | Finance | joni |

+-------+---------+------+

This is what I want as output: 

+-------+---------+------+--------------+----------------+

|  ID   |  group  | name | description1 |  description2  |

+-------+---------+------+--------------+----------------+

| 01:01 | IT      | bob  | soft         | install soft   |

| 12:04 | Finance | joni | soft         | uninstall soft |

+-------+---------+------+--------------+----------------+

How can I find this information using ID? 

1 Answer

0 votes
by (47.2k points)
edited by

In order to find the information, you should be able to connect both excel files to tableau. Therefore you will have two data sources. You then will form a relationship between the two sheets based on a common id. In this case, it will be the field "ID". You can then drag in the pills you need to the shelf to form the table as above.

  1. Connect both data excel data sources to the workbook

  2. Now, Navigate to the sheet1 and you will see both data sources listed in the top left-hand corner.

  3. Select the first sheet and navigate to Data-> Edit Relationship(on the top menu bar)

  4. Select the "custom" in the bullet menu

  5. Select the add button, and in the pop, window choose to link the data on the ID to id

  6. Select OK

  7. Your data is now blended and you can drag in your fields from both data sources and get the results you listed.

Further, enroll for an online training course to clear the Tableau Desktop Specialist Certification exam. I would recommend this Tableau Desktop Certification Program by Intellipaat. 

Related questions

0 votes
1 answer
asked Dec 16, 2020 in Python by laddulakshana (12.7k points)
0 votes
1 answer
asked Aug 31, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.7k users

Browse Categories

...