Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to link tables/excels with more than one common columns

I have 2 excel sheets project and Sale

Both Project and Sale excel sheets have the field ProjectID and saleID. I need to link the two tables avoiding a synthetic key.

Is it suggested that I comment SaleID in the Sale file and link both Project and Sale file using ProjectID.

Please give me a solution so that there are no data issues.

2 Replies
swuehl
MVP
MVP

Please avoid posting the same request multiple times.

It makes it hard to follow a discussion and is a waste of ressources.

How to link 2 tables with more than one common fields

nevilledhamsiri
Specialist
Specialist

Do a left join so that you may get the one common field right in the left with no synthetic keys being created!

Neville