Joins in tables to create new table visual

[Kapilchauhan555]

I have 2 tables table1 and table2, i want to create a new table visaul as described below

The combination of type and car is unique for each rows.

	Table1
Unique Cobination-->	Type	Car	Count	Salesman
	Diesel	Dzire	1	Ram
	Petrol	xl6	2	Rajan
	Hybrid	swift	3	Rita
	Diesel	Thar	3	Rita
	Petrol	Rapid	2	Ram
	Hybrid	Thar	1	Rajan

Table 2
Unique Chesis#	Car	Type
1	Dzire	Diesel
2	Thar	Diesel
3	Thar	Diesel
4	Thar	Diesel
5	xl6	Petrol
6	xl6	Petrol
7	Rapid	Petrol
8	Rapid	Petrol
9	swift	Hybrid
10	swift	Hybrid
11	swift	Hybrid
12	Thar	Hybrid

Desired table
Unique Chesis#	Salesman
1	Ram
2	Rita
3	Rita
4	Rita
5	Rajan
6	Rajan
7	Ram
8	Ram
9	Rita
10	Rita
11	Rita
12	Rajan

[Dhairya]

Hey @Kapilchauhan555 
Please follow the below steps to achieve the expected output

Step1: Create a calculated column in both table

Step2: Configure the relationship from table1 to table2 based on newly calculated columns

Step3: Plot the required columns

You will get the expected output.

If it works then please mark my solution as accepted and kudo the post so that others can find it quickly while facing a similar issue. Thank You!