Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

compare two columns

Hi,

i have 2 tables and i need the compare the country2 with the Country2 and if both are equal it should get corresponding Sub_Country

Country1:

Sub_CountryCoutnry1
US01US
Ind01Ind
Uk01UK
Ind02East Ind
Ind03West Ind

Country2:

Country2
USA
INDIA
UK
INDIA

Note: there is no common column exists

Labels (1)
10 Replies
Anonymous
Not applicable
Author

there is no way around it.

a computer can not (correctly) interpret data without a set of defining logic that provides context/instructions/rules for interpretation.

for example, it isn't feasible to suggest that there is a way to identify programmatically that the values "East Ind","West Ind", and "Ind" are all equivalent to the correlated field value "INDIA" without the use of a mapping/attribute table which defines the relationship.