Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gr_eldred
Creator II
Creator II

Mapping and Applymap

Good afternoon, I need help.

I have to do a mapping to add a column to a table and try it with a left join adding a Distinct, but it modifies my number of records.


The other option is an applymap to add the column Clave_Suc_Direccion but I can not relate these two tables in the applymap since the names of the columns are different.


This is my mapping:


Map_Cve_Suc_Direction:

MAPPING

LOAD

Pto_vta_Sucursal_ID as Cve_Suc,

Clave_Suc_Direccion

DESDE

Transformation \ Dim \ Suc_Pto_vta.qvd

(qvd);


This is my applymap:


ApplyMap ('Map_Cve_Suc_Direction', Cve_Suc, 'N / A') as Clave_Suc_Direccion



Is there any way I can accept an alias?


the relationship must be the data in the column Pto_vta_Sucursal_ID with the column Cve_Suc.

In the image there are the two tables that have to be related.

The column must be inside the Cat_Almacenes

tablas.png

Can somebody help me?

2 Replies
Anil_Babu_Samineni

What if you do something like below?

ApplyMap ('Map_Cve_Suc_Direction', Pto_vta_Sucursal_ID, 'N / A') as Clave_Suc_Direccion

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Lisa_P
Employee
Employee

The names of the fields in the mapping table do not matter.  The only things that matter is the load order of the mapping table fields (1st field is the matching field and the second is the one that is brought in to the destination) and the format of the fields must be the same.  The Cve_Suc is the field in the destination table to link with.