topic Mapping field from 2 different tables in QlikView

Mapping field from 2 different tables

Anonymous — Thu, 02 Jul 2015 11:57:23 GMT

Hi,

I have a concatenated table with a field called ID# (all in one tab).

I have an table called Overview with field named Identification Number in a separate tab under a Qualify load statement. I set it so that

Identification Number as ID#

When I load it the 2 fields don't map and it shows this field as Overview.ID# However, when I change the first table to ID# as Overview.ID# then the mapping happens. Is it possible to map it the other way around?

Thank you.

Re: Mapping field from 2 different tables

Anonymous — Thu, 02 Jul 2015 11:59:28 GMT

Hi,

is possible to have sample data?

Regards.

Re: Mapping field from 2 different tables

Anonymous — Thu, 02 Jul 2015 12:07:41 GMT

Hi Jennifer,

the mapping is not working proeperly because of the Qualify load. If you use Qualify in your script the field name will be aliased with your tablea name for eg., Table Name = A, Filed Name = ID the result of qualify will be A.ID. So Just remove the table name infront of the ID field in your second table (which is qualified) automaticaly the mapping will happened.

Before doing this make sur that the data in this two field are same and make sure that you want to map only this field.

Regards,

Nandha