Some joins are made to add other fields from other tables (also created from text files), and in the end, the qlik script generates an output text file that serves as input for an Access application. This file have unique records as I used distinct clause, but there are records that are very similar being stored at the output text file, which makes the access application work bad and mix up things. Here is an example:
I need to make the script read the text files and store in the output file only the first occurrence of the record based on its key, ignoring any other records with the same key value. I've tried using FirstValue but not successfully. Any ideas?