topic Re: applymap in QlikView

applymap

raadwiptec — Fri, 11 Dec 2015 08:17:36 GMT

hi all,

I have a scenario --

my mapping table is as below and based on the compid and productsoldto --- I will take the country details

compid productsoldto country

1 lptransport uk

2 usainctransport usa

3 califtransport afg

4 xxxxx ken

5 abc cape

my main table has the following data -

country sales products

we load this main table from an external file - before loadng and applymap is in the code which checks the mapping table then loads the country details

in the excel sheet I get few additional company ids which is not in the mapping but I want to see to that it has to be along with

for ex

excel sheet - so for 44 I want include in the apply map with 4

compid sales products

Re: applymap

Anonymous — Fri, 11 Dec 2015 08:20:54 GMT

see this:

quick applymap example

http://www.learnqlickview.com/a-qlikview-tutorial-mapping-load-in-qlikview/

ApplyMap Function in Qlikview - YouTube

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

Re: applymap

raadwiptec — Fri, 11 Dec 2015 08:32:18 GMT

Hi Balraj,

I need add an additional company id without adding it into the mapping table? and further doing it in apply map

Re: applymap

its_anandrjs — Fri, 11 Dec 2015 08:35:38 GMT

In the mapping only unique values get mapped other wise use joins here or simple association on the application.

For more please share sample file.

Regards,

Anand

Re: applymap

Anonymous — Fri, 11 Dec 2015 08:37:52 GMT

then you need this first:

Incremental load without date in Database

Incremental Load without Updated Date and Time

First fetch all the new Company IDs from excel using Incremental then applymap

Re: applymap

raadwiptec — Fri, 11 Dec 2015 08:59:05 GMT

hi anand yes ur correct only unique value get mapped. So if their is an non unique value then I would like to consider it along with one of them for example#

compid sales products

so here 44 is non mapped. probably in a if ondition if 44 then ......it is as 4.

Re: applymap

raadwiptec — Fri, 11 Dec 2015 09:04:55 GMT

hi all is their a way where I can concatenate or anything different where I can code that if it Is 44 then its '4'

Re: applymap

Anonymous — Fri, 11 Dec 2015 09:30:41 GMT

after mapping, you have to write like this:

If(CompanyID='44','4',CompanyID) as CompanyID