Sync keys issue

[#1]

Dear All,

I have following scenerio,

Users:

load * inline [

userid, username

1, 'UserOne'

2, 'UserTwo'

3, 'UserThree'] ;

Opportunity:

load * inline [

opportunityid, userid, date

1, 1, '10/10/2012'

2, 1, '10/10/2012'

3, 1, '10/10/2012'

4, 2, '10/10/2012'

5, 2, '10/10/2012'

6, 3, '10/10/2012'] ;

Lead:

load * inline [

leadid, userid, date

1, 1, '10/10/2012'

2, 1, '10/10/2012'

3, 1, '10/10/2012'

4, 2, '10/10/2012'

5, 2, '10/10/2012'

6, 3, '10/10/2012'] ;

Order:

load * inline [

orderid, userid, date

1, 1, '10/10/2012'

2, 1, '10/10/2012'

3, 1, '10/10/2012'

4, 2, '10/10/2012'

5, 2, '10/10/2012'

6, 3, '10/10/2012'] ;

Calendar:

Load * Inline [

date, year, month

'10/10/2012', '2012', '10'

]

Below is the Syn key shown. how can i remove sync key and be able to select data by both date and userid

Kind Regards,

Muhammad Naveed

[#2]

Join  Opportunity, Lead, Order tables to User Table. Then join Calendar table to user Table and drop all the original tables except User table

[thomas_skariah]

Hi Naveed,

You can refer the below attcahed qvw file.

Regrads,

Tom

[Siva_Sankar]

Hi Muhammad Naveed,  Find the attached file.