Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
claudialet
New Contributor III

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