topic Mapping Logic in QlikView

Mapping Logic

Tue, 18 Feb 2014 05:55:48 GMT

Dear All,

I have an application and I want to change a dimension data with another data with the help of mapping..

Example:

Display Name(Application data) field will map to Display Name1(Excel) and Division(Application data) map to Division1(Excel).

Please reply soon..

Re: Mapping Logic

sujeetsingh — Tue, 18 Feb 2014 06:32:40 GMT

use Applumap()

Re: Mapping Logic

albertovarela — Tue, 18 Feb 2014 06:48:15 GMT

Step 1: Load the mapping table

NameMap:

Mapping LOAD

Code1,

Description1

From Sample.xlsx (ooxml, embedded labels, table is [example table]);

Step 2: Load table and apply the map

Table:

Load

Code1,

Name1,

ApplyMap('NameMap', Code1, Code1) as Description

From Sample2.xlsx (ooxml, embedded labels, table is [example table 2]);

Re: Mapping Logic

amit_saini — Tue, 18 Feb 2014 06:50:56 GMT

Hi Rahul,

Use here applymap fuction. Mentoned below is the example:

[tmpData1]:

LOAD * INLINE [

F1, F2

1, 100

2, 200

3, 300

4, 400

5, 500];

[Mapping1]:

MAPPING

LOAD * INLINE [

CusID, CustName

1, AA

2, BB

3, CC];

[TestApplyMap]:

LOAD

F1 AS CustomerID,

APPLYMAP('Mapping1',F1,'-') AS CustomerName,

F2 AS Amt

RESIDENT [tmpData1];

DROP TABLE [tmpData1]

Re: Re: Mapping Logic

Tue, 18 Feb 2014 06:52:08 GMT

Its not working on appling Apply man.. pLz find attachment.

Re: Re: Mapping Logic

Tue, 18 Feb 2014 06:55:47 GMT

I understand applymap but its not giving the right result plz find my latest attachment..

Re: Mapping Logic

er_mohit — Tue, 18 Feb 2014 06:58:01 GMT

Try this Code as example

ADC:

MAPPING LOAD RowNo() as Key, * INLINE [

Country

IND

AUS

];

Map COUNTRY using ADC;

LOAD * Inline [

COUNTRY

INDIA

AUSTRALIA

WESTINDIES

NEWZELAND

];

Re: Re: Mapping Logic

Tue, 18 Feb 2014 07:13:12 GMT

Yes I thought Mapping load will work but can anyone tell me how to use it in my application..

Re: Mapping Logic

Tue, 18 Feb 2014 08:09:19 GMT

Mapping load would be what you require from what I have understood. Maybe look into the lookup function as well. Will match a field value to a field value you want from a table you specify

Re: Re: Re: Mapping Logic

Peter_Cammaert — Tue, 18 Feb 2014 08:09:45 GMT

Your example QVW does it wrong. First create two mapping tables, then use them trough applymap() when loading data to be translated from any source into a resident table.

The two mapping tables have two columns: the first one is the original data, the second contains the translations. All the above examples by community members do explain how to create mapping tables.

For your case, do this:

MapPersons:

MAPPING LOAD [Display Name], [Display Name1]

FROM PutExcelSourceHere.

MapDivisions:

MAPPING LOAD [Division], [Division1]

FROM PutExcelSourceHere.

Employees:

LOAD [Display Name] AS [Original Display Name],

applymap('MapPersons', [Display Name]) AS [New Display Name],

[Division] AS [Original Division],

applymap('MapDivisions', [Division]) AS [New Division],

FROM PutEmployeeSourceHere;

Replace your Main 2 code with this example code, but do not forget to adapt it to your particular situation. Your document does not contain enough information for a use case.

Best,

Peter