Synthetic Key Problem

Fri, 23 Aug 2013 06:41:35 GMT

Hello Community,

I'm having trouble with synthetic keys. I've gone through several posts but I can't get my scenario to work.

I have two tables which both have the following columns: Month, Year, Date and Department. The rest of the columns has no connection between the two tables. I also have a category column to let me distinguish between both tables.

So each table will get its own sheet but since I want to use those 4 columns as selection and listboxes and also add a Dashboard where both tables are shown I need a way to remove the synthetic key that is being created.

What are my options here?

I'm guessing I can combine Category+Department+Date to get a unique KEY. But how do I continue from there? I also want to use a Master Calendar table.

TABLE ONE:

Category	Department	Year	Month	Date
ONE	A	2012	1	2012-1-1
ONE	A	2013	2	2013-2-1
ONE	B	2012	1	2012-1-1
ONE	B	2013	2	2013-2-1

TABLE TWO:

Category	Department	Year	Month	Date
TWO	A	2012	1	2012-1-1
TWO	A	2013	2	2013-2-1
TWO	B	2012	1	2012-1-1
TWO	B	2013	2	2013-2-1

Thank you.

Re: Synthetic Key Problem

luciancotea — Fri, 23 Aug 2013 06:47:05 GMT

Concatenate the tables:

LOAD * FROM table1;

concatenate LOAD * FROM table2;

Re: Synthetic Key Problem

khadeer — Fri, 23 Aug 2013 06:49:19 GMT

Hi,

There is no need to give association . Just you have to concatenate both tables.

Regards,

Khadeer

topic Re: Synthetic Key Problem in QlikView

Synthetic Key Problem

Re: Synthetic Key Problem

Re: Synthetic Key Problem