link tables

[#1]

Hi,

I have two tables as A and B.

Table A has Customerid,loggeddate,ticketcount. And the Table B has Customerid,closeddate,ticketcount. So i want to make this as a single table.

As Customerid,date,loggedticketcount,closedticketcount.. How to get the same. I should use join or mapping function.Please suggest.

[deepakk]

Hi XXX,

Load

Customerid,

..... from Table a

join

Load

Customerid... from table b

make sure the Customerid name is same.

[maneshkhottcpl]

hi,

U can concatenate the tables using the flags and the flag can be used for further calculation in chart.

e.g.

AB:

load

Customerid,

loggeddate,

ticketcount ,

'A' as Flag

from Tablesname;

concatenate

load

Customerid,

closeddate as DateAB,

ticketcount as TicketAB,

'B' as Flag

form TableB;

[deepakk]

hi,

Ops it will be better to concatenate....

Load

from Table a

concatenate

Load

From Table b

[#5]

Thanks deepak,

But Concatenate will create a table with all rows from table A and all rows from Table B. But i want the output like this

Table A

Customer id , Arrivaldate, loggedcount

c1 02/02/2011 12

c2 02/03/2011 10

c1 02/03/2011 50

Table B

Customer Id, closeddate, closedcount

c3 02/02/2011 12

c2 02/03/2011 10

c1 02/03/2011 50

Output as

Customerid, Date, loggedcount,closedcount. .

c1 02/02/2011 12

c1 02/03/2011 50 50

c2 02/03/2011 10 10

c3 02/02/2011 12

Please suggest

[deepakk]

hi,

When concatenating just change the field name of the Count fields as loggedcount and closedcount and you will get the result

[#7]

Thanks Deepak,

I tried both Join and concatenate.

Outcome is same in terms of count and other things. But the way the concatenate displays is each thing like below

Customer Date Loggedcount closedcount

c1 02/03/2011 10

c1 02/03/2011 20

But join displays as

Customer Date Loggedcount closedcount

c1 02/03/2011 10 20.