Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
both the tables have different different field
I want to link up with Manali = MANALI data
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;
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()
Choose one of these and apply it to all LOAD statements that import data into the same field and in a consistent way.