How to make My GL Table date_GL field link to master calendar date ?

[paulyeo11]

HI ALL

My GL Table , date field name = date_GL , i use below script to chk the min and max date :

tmp:

LOAD

  min(date_GL) AS MinDate,

  max(date_GL) AS MaxDate

RESIDENT GL_TABLE;

My sales table , date field name = date , i use below script to chk min and max date :-

CONCATENATE (tmp)

LOAD

  min(date) AS MinDate,

  max(date) AS MaxDate

RESIDENT sales_table;

My question is how to make both date , date and date_GL able to link to master claendar ?

The reasons i use diff field name for both table on date , is because i just want to make sure that it will check min and max date correctly.

Paul

[paulyeo11]

Enclosed my data model.

[selcukcadir]

hi paulyeo11, can you add an example qvw file?

[paulyeo11]

Hi Selcuk

Thank you for your help.

[paulyeo11]

Hi All

Can some one advise me pls.

Paul