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.

[saumyashah90]

Hi Paul,

Left Join(Quotation)

Load * from Inquirytable;

Left Join(Master Table)

Load * from Quotation;

will resolve your problem

[#3]

Hi Sir

I try below :-

load *,

Date as cal_date

from

Inquiry.qvd (qvd);

This time no error , but the Date field does not rename to new name ?

Paul

[#4]

Hi Sir

I try to create link key from quotation table using Ref. No and Date field . like below :-

AutoNumberHash128('Ref. No','Date') As Link_Key,

or

Autonumber( 'Ref. No' & '_' & 'TDSS' ) as INVKey,

but no work.

[#5]

What is the date field in the master calendar that you want to link the other dates to?

try this:

load *,

Date as <your_date_field_in_master_calendar>

from

Inquiry.qvd (qvd);