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

[techvarun]

Use Upper(Location)  as location in table A

[techvarun]

Use

Upper(Location)  as Location in both table A and B or

Lower(Location)  as location in both table A and B

we are doing the same in both the tables to keep consistency.

Upper and Lower to chose between uppercase and lowercase depends on your requirement.

[qlikcheepirishe]

Table A -->Location

but in

Table B -->Loc AS Location so it is not mapping by upper case

[techvarun]

TableA:

Load * Inline [

Location,Geog

Kanjurmarg,Mumbai

];

TableB:

Load * Inline [

Loc,State

KANJURMARG,Maharashtra

];

noconcatenate Load upper(Location) as Location, Geog Resident TableA;

noconcatenate Load upper(Loc) as Location, State Resident TableB;

DROP Tables TableA,TableB;

try the above code

[qlikcheepirishe]

Not working as required

[techvarun]

Share a sample qvw or data

[Anil_Babu_Samineni]

Can you share few rows of data and expected result

[qlikcheepirishe]

Data in table has the same value just it is not merging

T1:

DATA

T2:

data AS DATA

now location manali in T1

        location MANALI in T2

the data present in manali both are the same

[Anil_Babu_Samineni]

Upper() should work for this while using Concatenate(T1) betweek T1 and T2 ..