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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Two Excel sheets with more than one common fields

How do I link these tables. One is Project details and the other is Sales details. Both Excels have ProjectID and SaleID. Project Details is more on the Status values and Sales is about budget , forecast information.

1 - What should be the key to join the two tables

2 - is it ok if I comment the SaleID in the Sale Table and link both the PRoject and Sales Excel with ProjectID field

Please let me know if doing so by commenting would not cause any data issues . The link would be on the higher umbrella ProjectID. SaleID is a subset to each Project. Please let me know if it will work on commenting saleid in the second excel

3. do I need to build my key by using both these keys - don't know how to do that. can you please give me the syntax and explain.

is it necessary in this case - i.e. if I use the approach in 2, will it be correct.

all early responses appreciated

0 Replies