Composite Key in set analysis

[nareshthavidishetty]

Hi all,

I have a table like,

   table1:

date	city	count1
21/02/1990	Pune	1
22/02/1990	Tamilnadu	2

  table2:

date	city1	count2
21/02/2050	bangalore	2
21/02/2051	Ap	3

I have the data like this in different tables, with out concatenate(data was different in each table) .my requirement is ,i want to see the data like this in straight or pivot table

date	city	count
21/02/1990	Pune	1
22/02/1990	Tamilnadu	2
21/02/2050	bangalore	2
21/02/2051	Ap	3

My Approach:

Load count1,date&'-&city as key table1;

Load count2,date&'-&city2  as key table2;

set analysis:count({<SubField(key,'-',2)={"Ap"}>}count2);result should be :1,(i have created variable also)

but my approach was wrong in set analysis,can any one please help me on these,

Warm Regards,

Naresh