topic Re: Mapping in QlikView

Mapping

smilingjohn — Fri, 05 Feb 2016 14:25:19 GMT

HI All ,

Can someone please tellme what is maaping in qlikview .

I have been told to MAP the below things .

Model.cad= ModelView.cad

Model.Game= ModelView.Game

Can please someone tell me what is this and can u give me a very simple example for the same

Thanks in Advace

Anonymous — Fri, 05 Feb 2016 14:32:37 GMT

They could well be referring to Applymap, if so then this blog explains it :

smilingjohn — Fri, 05 Feb 2016 14:48:44 GMT

Thanks bill

Can you please give me an example with the above requirement i have mentioned , It will be really very helpfull for me

Anonymous — Fri, 05 Feb 2016 14:54:13 GMT

Do you have these fields in your current data model ?

Model.cad

ModelView.cad

Model.Game

ModelView.Game

smilingjohn — Fri, 05 Feb 2016 14:57:55 GMT

yes i have this fields

Actaully its an excel sheet with 4 fields in each and there are two 2tables

Table:Model

cad

Game

Dept

Location

Table : ModelView

cad

Game

City

Code

sathishkumar_go — Fri, 05 Feb 2016 14:58:12 GMT

Hi,

Please explain me your requirement clearly with sample data.

-Sathish

swuehl — Fri, 05 Feb 2016 15:06:07 GMT

I think it's more about linking key fields of tables rather than mapping field values, then?

If you don't qualify the table LOADs,the tables should automatically link by these two fields, cad and Game.

To avoid a synthetic key, you can create a composite key made out of these two fields.