How to link Multiple date fields to one date in one table

[#1]

Hi,

I Have Data like this

Assign Date  open  open_date       close  close_date  Isuue_status 

12/4/2012      abc    11/4/2012       abc     12/4/2012    closed

Like this i have data for caculation of open : i use opendate

                              for calculation of close: i use close date

i need a pivot table with single date or month field across dates ie

Months   Open_count  close_count

Jan-12           12             10

feb-12            10               0

Like this i need one date field  but for calculation of open_count we should use open date and close_count we should use close_count

Regards,

Madhukumara

[#2]

Hi,

As per my understanding you want to select a period like a Month say Jan-2012 and you want to see the Open Count and Close Count for this period. So do one thing-

Table:

open,

open_date,

Isuue_status,

open_date as Date

concatenate

//same table

close, 

close_date  as Date ,

Issue_status

now select this Date field or link this to a calendar u ll get both open n clased data.

Thanks n Regards

Apurva

[#3]

Hi,

How to link dates and same table we shoud concatenate?

regards,

madhukumara

On Fri, Jun 15, 2012 at 12:22 PM, Apurva ... <

[#4]

Hi,

there is a keyword CONCATENATE use this. suppose your table name is A.

A:

load *,

open_date as Date

from A;

CONCATENATE

load *,

close_date as Date

from A;

regards

Apurva