Skip to main content

Qlik Application Automation

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
neon
Contributor II
Contributor II

How to delete common records from 3 tables.

 
Labels (1)
1 Reply
Dan-Kenobi
Partner - Contributor III
Partner - Contributor III

Without context, it makes it a little hard to give you a straight answer but I'll try:

If you're building a fourth table reconciling the data from the three tables, I'd ask you to simply join the dups and create additional fields with aggregations -- or the numbers you're insteresting in.

If you're thinking "If it exists on all three, I don't care about the records" -- usually when you're checking what rows have not replicated to the other zones - then you can do a set analysis on your dashboard where the count of your rows are < 2 ... 

You can do it on the Qlik Script too, and on the database too. 

 

If you can provide more context (maybe your data models) and your actual result (on a Dashboard, or a physical deletion of the data), I htink I can be more precise on my response.

 

Thank you and Happy Qliking