join

[raadwiptec]

hi all,

Iam facing the following issue...Ibasically i need I[nvoice doc] to autojoin with invoice doc of file 2  and i need the amount and amount_pound ... am not using apply map as my results are worng..

the problem iam facing is synthetic keys..iam getting invoice doc and month as syn keys. iam neither able to drop it is their any other way?

Test1;

Load,

Num(Left([Invoice Number],6)) as [InvoiceDoc],

[Account Numbert],

Month([Innvoice Date]) as Month,

[Amount ]

from xxxxxx.file 1

Test2;

Load,

[InvoiceDoc],

Month,

[Amount _Pounds]

from xxxxxx.file 2

[swuehl]

Rename one of the Month to [Invoice Month] if they are describing different roles of the month. If they are describing the exact same role, I think you can keep only the field in the 'master' table and drop the field from the other table.

Test2;

Load,

[InvoiceDoc],

Month as [Invoice Month],

[Amount _Pounds]

from xxxxxx.file 2