Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikcheepirishe
Creator
Creator

Associating the same field in two different tables

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

12 Replies
techvarun
Specialist II
Specialist II

Use Upper(Location)  as location in table A

techvarun
Specialist II
Specialist II

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
Creator
Creator
Author

Table A -->Location

but in

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

techvarun
Specialist II
Specialist II

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
Creator
Creator
Author

Not working as required

techvarun
Specialist II
Specialist II

Share a sample qvw or data

Anil_Babu_Samineni

Can you share few rows of data and expected result

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
qlikcheepirishe
Creator
Creator
Author

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 ..

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)