Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

tiny question about ApplyMap syntax

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!

1 Solution

Accepted Solutions
MVP
MVP

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.

View solution in original post

5 Replies
MVP
MVP

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.

View solution in original post

Not applicable

I think you would have to type this:

'drop table Order_table';

at the end

to not have ProductId...

Employee
Employee

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)

Not applicable

MapProducts: 

MAPPING LOAD  ProductID,  description

from <table>;

tab2:

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

drop table Order_table;

Not applicable

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!