Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using Qlik Sense and I have a straight table with columns: firstName, lastName, address, city, state.
I need to find any records that have duplicated firstName and lastName together and then of those that are duplicates I need to find any that have duplicates in 2 of the 3 other columns. And then I need to display the duplicates together in rows. So, the first duplicates would be in rows 1 and 2, the next set of duplicates would be in rows 3 and 4 and so on.
Is there a good way to do this? Would an Arrg function or a P function work? I am new to Qlik Sense.
Thank you for your help.
Anyone?