topic Re: synthetic keys in QlikView

synthetic keys

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

i have 2 tables

Table 1

============

Month

Year

.Prices.

Some additonal colums

I Store table 1 in QVD format as table2.qvd each month as back up for reference...as the actual Table 1 changes its prices end of month and it would further change all the data with in table 1 irrespective of month

Now I take the data from table2.qvd and display it in a chart from the back up qvd/s

The issue here is i have a common list box for Month and year. so when iam loading table 2 synthetic is getting formed. for month and year................................

Re: synthetic keys

adamdavi3s — Thu, 15 Sep 2016 12:42:34 GMT

have a check on here for canonical dates and/or link tables as this should help solve your issue.

There should be plenty of of answers to help.

Re: synthetic keys

Anonymous — Thu, 15 Sep 2016 12:43:32 GMT

can you concatenate table2 into your existing table?

then no syntetic key will be created

and fro mour description I assume that the data is not overlapping

(different months)

The name of your fields remain same in Table2?

Re: synthetic keys

raadwiptec — Thu, 15 Sep 2016 13:07:43 GMT

how do we concatenate just 2 columns month and year?

Re: synthetic keys

adamdavi3s — Thu, 15 Sep 2016 13:09:50 GMT

year&'-'&month

something like that in your load script will do it

Re: synthetic keys

Anonymous — Thu, 15 Sep 2016 13:12:17 GMT

can you explain more in Detail? what do you store in Table2.qvd?

as Prices Change every month you would need to store Prices and id as well in table2???

and then you Need to load all 4 fields again

as you wrote you get syntetic key for year and month only?

can you post your script and explain why you only load year and month