Mapping a key field

[#1]

Good afternoon,

I´ve got a star scheme for controlling data revolving around an order number, with tables like

TransactionalData:

OrderNr

Month

Account

Value

OrderMaster:

OrderNr

Name

AccountMaster:

Account

AccountName

For capital expenses, instead of the normal OrderNr the data will contain an investment order nr .There is a mapping table MapTable with fields

OrderNr (example Opex1234)
InvestmentOrderNr (example Capex9876)

If I get 'Capex9876' in the OrderNr field, how can I substitute that by Opex1234, while keeping the field name OrderNr?

Thanks!

[Gysbert_Wassenaar]

You can use the ApplyMap function for this:

MapTable:

Mapping Load OrderNr, InvestmentOrderNr From ...mymappingsource...

MyTable:

LOAD

     ...some fields...

     ApplyMap('MapTable',OrderNr) as OrderNr

FROM

     ...mysourcetable...

[rajeshforqlikvi]

HI,

May be some values of both the column (OrderNr) may not match but if for that transaction table (TransactionalData)

the required master table is (OrderMaster) then of course some values will be also match. else you need to consult your BA. for data details

Regards

Rajesh kumar