topic Re: Is it possible to see inside a mapping table? in QlikView

Is it possible to see inside a mapping table?

Tue, 01 Jul 2014 05:46:27 GMT

Hi, is it possible to see inside my mapping table?

1. I've got a standard table called tblActivity.

A resident load is done to get a mapping table:

Map_ActivityNo_Desc:

MAPPING LOAD

ACTIVITY_NO

, DESCRIPTION

Resident tblActivity;

But how to I see what's inside this mapping table?

2. What happens when the mapping table contents are not unique? Does it just give you the first one?

tresB — Tue, 01 Jul 2014 05:50:35 GMT

To see mapping table, just load it as general table, like:

1. Load * Resident tblActivity; // now, in the front-end you can see them.

2. Yes, it just gives you the first mapping result.

jagan — Tue, 01 Jul 2014 05:52:35 GMT

Hi,

Load the without the mapping keyword and validate the date, after that you again assign the mapping keyword, this is the way you need to do.

If the values are not unique then you will get the first record value.

Regards,

Jagan.

Tue, 01 Jul 2014 06:20:09 GMT

Thanks tresesco and Jagan,

Much appreciated .

Jagan, I'm not sure what you mean by "validate the date" though... I don't see any date anywhere and I don't know exactly what to do to validate it.

jagan — Tue, 01 Jul 2014 07:48:46 GMT

Hi,

Sorry for the Typo mistake, it is data not date.

Regards,

Jagan.