topic Re: Mapping Table in QlikView

Mapping Table

nihhalmca — Fri, 08 Nov 2013 04:17:36 GMT

Hi All,

Why max of columns are 'TWO' in mapping table

Thanks in Advance

Nihhal

Re: Mapping Table

sushil353 — Fri, 08 Nov 2013 04:50:37 GMT

Hi,

When you use applymap function there you can only pass one field which is going to be compared with the 1st column of the mapping table... and values are mapped with second column of the mapping table..

there is no way to specify the no of column to be compared and map.. that is why we are having only two column in mapping table.

HTH

Sushil

Re: Mapping Table

Fri, 08 Nov 2013 06:03:06 GMT

Hi NIhhal,

When you are implementing ApplyMap().

You need to refer only two columns, 1 MapID, 2 MapValue.

Example:-

MapID MapValue

M Mumbai

K Kolkata

C Chennia

So, you don't need to refer 3rd column.

Hope this might help you.

I welcome all your comments and feedback.

Regards,

Pavan Kumar.