Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Did you explore Exists - script function | Qlik Sense on Windows Help
hi,
are you able to give me an example on how exist would work for me?
you can share sample dataset to check, so that we will have a look and share the sample script for you to turn on.