Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jblomqvist
Contributor II

Terminology question: Is Composite Key the same as Concatenated Key?

Hi all,

I have seen some blogs mention using a composite key to handle synthetic tables. Is this the same as creating a concatenated key?

I get confused by the terminology so just want to check what composite key means exactly.

Thanks

1 Reply
stigchel
Honored Contributor

Re: Terminology question: Is Composite Key the same as Concatenated Key?

Yes it is, it is a combination of two or more columns in a table that can be used to uniquely identify each row in the table. Uniqueness is only guaranteed when the columns are combined; when taken individually the columns do not guarantee uniqueness

Community Browser