topic Mapping a key field in QlikView

Mapping a key field

Thu, 14 Jan 2016 13:49:16 GMT

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 — Thu, 14 Jan 2016 16:45:43 GMT

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 — Thu, 14 Jan 2016 16:56:39 GMT

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