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

[Akuma2025]

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.

Qlik Sense Desktop 

[Anil_Babu_Samineni]

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

[Akuma2025]

hi, 

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

[Anil_Babu_Samineni]

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