Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | Independent Col |
---|---|---|---|---|---|
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 | Independent Col |
---|---|---|---|---|---|
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.
Concatenate the tables:
LOAD * FROM table1;
concatenate LOAD * FROM table2;
Concatenate the tables:
LOAD * FROM table1;
concatenate LOAD * FROM table2;
Hi,
There is no need to give association . Just you have to concatenate both tables.
Regards,
Khadeer