topic Re: How To link 2 Tables with one unique Key to avoid synthetic key in QlikView

How To link 2 Tables with one unique Key to avoid synthetic key

Nawfal-Franke — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have a problem with my model.

I want to link two table "expéditions ventes" with "SalesInvoiceLine" with a unique key to avoid synthetic Key in my model, I want to concatenate ("Key Table with Order No") and use AutoNumber but I don't know how to do it .

Here is the details of my 2 tables :

ExpéditionsVente:

SalesInvoiceLine:

Thank you guys for your help.

Kind Regards

Re: How To link 2 Tables with one unique Key to avoid synthetic key

Nawfal-Franke — Tue, 12 May 2020 16:09:42 GMT

Hi guys,

Any help please I really need it to complete my application.
Thanks.

Kind regards

Re: How To link 2 Tables with one unique Key to avoid synthetic key

Brett_Bleess — Thu, 04 Jun 2020 13:50:53 GMT

The following Design Blog post should take care of helping you get things sorted:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett