I have a multiple documents with same field names(have 38 Fields). Each file have around 10 Lakh data. There are duplication across the files and also with in each file.
Now the requirement is I need to create a single file with all 38 columns by removing the duplicates. Removing the duplicate should be based on ID field. If ID is repeated we should only keep very 1st row and rest of the repeated rows can be deleted. it is not necessary to check the rest of the 37 fields. i.e., even if other columns vary still we are fine to delete the respective rows.
Let me know how can we achieve this in QlikView
