topic Re: tiny question about ApplyMap syntax in QlikView

tiny question about ApplyMap syntax

Tue, 29 Oct 2013 14:24:27 GMT

I was reading the great explanation regarding ApplyMap by Steve Dark

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

a question came up in my mind:

if I have

MapProducts:
MAPPING LOAD
ProductID,
description;

LOAD
Order
ApplyMap('MapProducts',ProductID,'N/A') as Item
RESIDENT Order_table;

is this expected to work perfectly, since I am not explicitly loading ProductID from the resident Order_table?

Further, by using this syntax, I should NOT expect to see the field ProductID in the dashboard, right?

thank you!

Re: tiny question about ApplyMap syntax

swuehl — Tue, 29 Oct 2013 15:06:52 GMT

I think your Mapping load misses a data source (FROM, RESIDENT etc.).

You don't need to explicitely load the ProductID in your table, and using above load you should not expect to see the ProductID field in your data model.

Re: tiny question about ApplyMap syntax

Tue, 29 Oct 2013 15:10:04 GMT

I think you would have to type this:

'drop table Order_table';

at the end

to not have ProductId...

Re: tiny question about ApplyMap syntax

Clever_Anjos — Tue, 29 Oct 2013 15:10:50 GMT

You creating your mapping table from your source table. It won´t work.

You should populate your Mapping Table before using it (inline, excel, whatever)

Re: tiny question about ApplyMap syntax

Tue, 29 Oct 2013 15:14:51 GMT

MapProducts:

MAPPING LOAD ProductID, description

from <table>;

tab2:

LOAD Order, ApplyMap('MapProducts',ProductID,'N/A') as Item RESIDENT Order_table;

drop table Order_table;

Re: tiny question about ApplyMap syntax

Wed, 30 Oct 2013 09:39:55 GMT

indeed, I left aside the RESIDENT for the mapping load, excuses.

And true that, ProductID will be appearing if Order_table is not Dropped.

But indeed, if Order_table is dropped, I understand ProductID is not going to be shown through the ApplyMap.

It is used to ApplyMap but not kept.

thank you for the answers!