Mapping Table

[nihhalmca]

Hi All,

Why max of columns are 'TWO' in mapping table

Thanks in Advance

Nihhal

[sushil353]

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

[#3]

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.