topic creating a new table with fields which come from more than 2 different tables in Data Quality

creating a new table with fields which come from more than 2 different tables

Akuma2025 — Mon, 30 Jun 2025 08:00:33 GMT

Hi,

i need to try and compare 2 datasets, abit like vlookup in excel.

The 1st dataset is an excel spreadsheet. which is a data entry spreadsheet, which includes, admission date, staff member, customer id, customer name etc

the 2nd dataset is a combination of different tables, which contain multiple fields. To explain further, dataset 2 is a combination of one table which includes; date of admission, recorded by staff member, and then another table, includes customer id, customer name etc. So information is coming from more than 2 tables.

Because the 2nd dataset is a combination of more than 3/4 tables.

i managed to get the information on a sheet table, so the data from one dataset is on one sheet and data from the 2nd dataset is on another sheet.

I now need to know how to compare these 2 sheets of data, and see what is missing from each one.

How do i try and compare if a customer from dataset 1 is and isnt on dataset 2 and the other way, how do i compare if a customer from dataset 2 is and isnt on dataset 1?

any help will be greatly appreciated.

Re: creating a new table with fields which come from more than 2 different tables

Anil_Babu_Samineni — Mon, 30 Jun 2025 08:36:06 GMT

Did you explore Exists - script function | Qlik Sense on Windows Help

Re: creating a new table with fields which come from more than 2 different tables

Akuma2025 — Mon, 30 Jun 2025 09:06:51 GMT

hi,

are you able to give me an example on how exist would work for me?

Re: creating a new table with fields which come from more than 2 different tables

Anil_Babu_Samineni — Wed, 02 Jul 2025 09:10:53 GMT

you can share sample dataset to check, so that we will have a look and share the sample script for you to turn on.