Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
claudialet
Not applicable

Can link tables be created from SQL SP's ?

So here are tables from SQL EXEC  SP's  that forms synthetic keys.

What is the best way to create link table to eliminate synthetic keys from a SQL EXEC commands ?

[Sales ] :

Sales ID

Order ID

Customer ID

[Orders] :

OrderID

CustomerID

ProductID

[Product]:

ProductID

OrderID

Sales ID