applymap

[raadwiptec]

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

1

2

3

4

44

5

[Anonymous]

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/

[raadwiptec]

Hi Balraj,

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

[its_anandrjs]

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

[Anonymous]

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

[raadwiptec]

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

1

2

3

4

44

5

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

[raadwiptec]

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'

[Anonymous · Accepted solution]

after mapping, you have to write like this:

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