Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?