Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Kapilchauhan555
New Member

Joins in tables to create new table visual

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-->TypeCarCountSalesman
 DieselDzire1Ram
 Petrolxl62Rajan
 Hybridswift3Rita
 DieselThar3Rita
 PetrolRapid2Ram
 HybridThar1Rajan

 

 

Table 2
Unique Chesis#CarType
1DzireDiesel
2TharDiesel
3TharDiesel
4TharDiesel
5xl6Petrol
6xl6Petrol
7RapidPetrol
8RapidPetrol
9swiftHybrid
10swiftHybrid
11swiftHybrid
12Thar

Hybrid

 

 

 

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

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

Step1: Create a calculated column in both table

Dhairya_1-1694861827077.png

 

Dhairya_0-1694861811037.png


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

Dhairya_2-1694861907278.png


Step3: Plot the required columns

Dhairya_4-1694861960115.png

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!


 



Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.