Associating the same field in two different tables

[qlikcheepirishe]

I have table A and table B I have field Location in both the table..

what i required is in both the table Location field has same field but the filed values are like

Table A Location-->Kanjurmarg

Table B Location-->KANJURMARG

So i want both the filed value should link up in planing as well as in budgeting

[qlikcheepirishe]

both the tables have different different field

I want to link up with Manali = MANALI data

[techvarun]

TableA:

Load * Inline [

Location

manali

];

TableB:

Load * Inline [

Loc

MANALI

];

noconcatenate Load Location as Location Resident TableA;

noconcatenate Load LOCATION as Location Resident TableB;

DROP Tables TableA,TableB;

[Peter_Cammaert]

With respect to data values, QlikView is case sensitive and you can't change that.

If you want all identical values - except for character case - to map to a single dimension value, you'll have to change those values in your load script.

As suggested many times before, your best options are:

Upper()

Lower()

Capitalize()

Choose one of these and apply it to all LOAD statements that import data into the same field and in a consistent way.