Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
letqi
Contributor II
Contributor II

Compare different table and display only the Unmatch data

Hi all, i have created a sample layout of what i want to do but am not sure how to execute this in script.

Table 1, Customer

Name Age Number
Anne 10 91121212
Ben 15 82342121
Cat 18 81321321

 

Table 2, Renamed Customer

Name Age Number
Anne 10 91121212
Ben 15 82342121

 

Output: 

Name Age Number
Cat 18 81321321
Labels (5)
1 Reply
letqi
Contributor II
Contributor II
Author

NoConcatanate

FinalTable:

Load * Resident Customer;

Add

Load * Resident Renamed_Customer

where not wildMatch(Name, Name);

 

i have tried this and failed. can anybody help me with this breakdown?