topic Re: Composite key in QlikView

Composite key

qlikview979 — Tue, 21 Apr 2015 16:20:22 GMT

Hi experts,

What is Composite key?

Re: Composite key

marcus_malinow — Tue, 21 Apr 2015 16:22:34 GMT

Mahesh, you're on a roll today. Interview coming up?

A composite key is where we concatenate two or more key fields together.

For example if I have a table with order number and order line I might do something like:

OrderNum & '_' & OrderLine as %KeyOrderNumLine

Re: Composite key

qlikview979 — Tue, 21 Apr 2015 16:24:58 GMT

Thanks,

Marcus

Re: Composite key

marcus_malinow — Tue, 21 Apr 2015 16:28:12 GMT

No probs, a 'Correct' would make my day though...

It's worth asking why we might use a composite key - typically I might use them to resolve a synthetic key issue.

Re: Composite key

buzzy996 — Tue, 21 Apr 2015 16:29:13 GMT

combination of multiple keys called as concatenate key.

Re: Composite key

qlikview979 — Tue, 21 Apr 2015 16:40:51 GMT

Thanks,

Shiva Reddy

Re: Composite key

buzzy996 — Tue, 21 Apr 2015 16:54:05 GMT

ur wc, if ur happy with any of the above answers,u can close by marking as correct this thread & all other as well

Re: Composite key

qlikview979 — Tue, 21 Apr 2015 17:02:39 GMT

Ok, but u wrote concatination, that is not concatination

that is composite key.

Re: Composite key

Tue, 21 Apr 2015 17:03:59 GMT

When one or more tables have two or more fields in common, then a composite key will be generated, then QlikView handles this process with a Synthetic Key.