Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nandhaadjame200
Contributor II
Contributor II

Synthetic Key Question - on Month & Region field which i'm using as filters

Hi There

Synthetic Key Question - on Month & Region field which i'm using as filters:

I'm having multiple tables with same set of fields which is really required for filters. If i rename or concatenate those fields, then i will not have separate fields for filter's. Also those filters were common for all dashboards which i created. 

Also I've attached my Data Model screenshot for reference.

Please check and advise if can continue with those synthetic keys or i should really worry about my data model.

 

Thanks

Nandhakumar

Labels (3)
1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

Hi Nandha,

Try like this:

Make a new key "Month &'|'& Region" in all the tables which have month and Region field and drop this filed from all the tables except the one which have all the month and region data (Master Table).

Table A:

Load

Month,

Region,

Month &'|'& Region as %Key

from Table A;

 

B:

Load

//Month,

//Region,

Month &'|'& Region as %Key

from Table B;

Do this for other tables as well. It will help in eliminating the synthetic keys and result in star schema.

Hope it helps.

Best Regards,
KC

View solution in original post

2 Replies
jyothish8807
Master II
Master II

Hi Nandha,

Try like this:

Make a new key "Month &'|'& Region" in all the tables which have month and Region field and drop this filed from all the tables except the one which have all the month and region data (Master Table).

Table A:

Load

Month,

Region,

Month &'|'& Region as %Key

from Table A;

 

B:

Load

//Month,

//Region,

Month &'|'& Region as %Key

from Table B;

Do this for other tables as well. It will help in eliminating the synthetic keys and result in star schema.

Hope it helps.

Best Regards,
KC
nandhaadjame200
Contributor II
Contributor II
Author

HiJyothish

Apologies for the delayed response.

Actually, your solution worked for me. Thanks a lot.

Thanks

Nandhakumar