my 2 table each have date , how to link them to master calendar date ?

[#1]

Hi All

if you notice that i have already link both date to master calendar. i wanted the inquiry date and quotation date both link to master calendar. but i am not able get it link . Any advise will be appreciated.

[jagan]

Hi Paul,

Concatenate both Inquiry and Quotation tables and include a flag in the table to differentiate the record type, check this below script

Data:

LOAD

     *,

     'Quotation' as TableName

FROM QuotationData;

Concatenate(Data)

LOAD

     *,

     'Inquiry' as TableName,

     Inq.Date_Inquiry to Q.Date

FROM Inquiry;

Now there is a single date field connecting to Master calendar.

Regards,

Jagan.

[#3]

Hi Jagan

Since the Quotation date and Inquiry date both of them are different date. for example same Ref.No can have 2 seperate date. So am i still able to make both the date same ? i guess it will be wrong right ?

[#4]

Hi Paul,

if your three fields are as cal_date,

inquiry_date and quotation _date,

when u load data, you can add two aliases as well:

inquiry tbl:

load inquiry_date,

inquiry_date as cal_date;

quotation_tbl:

load quotation_date,

quotation_date as cal_date;

Regards,

Anju

[senpradip007]

Hi Paul,

Create a Link Table with Inquiry and Quotation tables and then link the Master Calender with that Link Table.

By this way you can reach your goal.

Regards,

Pradip

[#6]

Hi Sir,

I must have miss out some thing ,  as i try below , but it still not work :-

load * from Inquiry.qvd (qvd);

Inquiry:

load Date,

Date as cal_date;

Inquiry:

load Inq.Qty_Inq,

Inq.Qty_Inq as Qty;

[#7]

try writing it together,

Inquiry:

load *,Date,Date as cal_date,Inq.Qty Inq,Inq.Qty_Ing as Qty from Inquiry.qvd (qvd);

Also, please rename cal_date to the correct name .... as you have named it in the master calendar.

Regards,

Anju

[#8]

Hi Sir

I try to put the code inside the load QVD code like below ( only try to rename the Date)  :-

load *,

Date,

Date as cal_date

//Inq.Qty_Inq,

//Inq.Qty_Inq as Qty

from

Inquiry.qvd (qvd);

I get error :-

Field names must be unique within table

load *,

Date,

Date as cal_date

from

Inquiry.qvd (qvd)

[jagan]

Hi Paul,

Please find attached file for solution, hope it helps you.

Regards,

Jagan.

[#10]

try this,

load *,

Date as cal_date

//Inq.Qty_Inq,

//Inq.Qty_Inq as Qty

from

Inquiry.qvd (qvd);