How to contentenance my exchange table with my date table with ?

[paulyeo11]

Hi All

I have below data model , from below script , may i know how to modify the script , so that these 2 table will be combine into 1 table ?

Temp:

Load

Date

($(vMin)+RowNo() -1) as DATE,

Date

(Floor(Monthstart(Date($(vMin)+RowNo() -1)))) as date_t

AutoGenerate

1

While

Date($(vMin)+RowNo() -1) <Date($(vMax));

RATE:

LOAD

date_t,

//     SOURCE,

EXCHANGE,

AUTONUMBER

(date_t&SOURCE) as compositeKey,

EXCHANGE_

,

Currency

FROM

Account_Setup_1.xls

(

biff, embedded labels, table is [RATE_$]);

[spividori]

Hi Paul.

How should the results be?

Do not work with: "concatenate"?

Regards.

[paulyeo11]

still struggle with it. you can help ?

[paulyeo11]

Hi eR

I got some error. see my enclosed QV doc.

Paul

[spividori]

Hi.

I would use "concatenate", but I do not know if this is the result you want.

See the example.

Regards.

[paulyeo11]

Hi Sir

Thank you very much for your help .

i just check , and notice that the date_t and DATE field are not link up.

date_t is my exchange date.

DATE  is my sales order date.

it is possible for help me join the 2 date ?

Paul

[spividori]

Hi.

Sorry, I can not understand what you need. Can you explain with an example. Thanks.

Regards.

[paulyeo11]

Hi Sir

Thank you very much for your help .

i just check , and notice that the date_t and Date field are not link up.

Field date_t field is date from exchange table.

Field Date is date from master calendar table.

Field date is my sales order date.

DATE  is my sales table date.

it is possible for help me join the 2 date from Table , date_t link to Date ?

See my QV doc.

Paul