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.

Related questions

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


Categories

...