Problem : I need to load a table from an excel but need to remove duplicate records based on a column for same Order_Numbers. For ex:
Below image shows the sample records in the Orders sheet that has unique Order_Number
Below image is of the MappingSheet in which I want to remove the duplicate records for each Order_Number based on the column "IssueType". So, MappingSheet can have multiple records for one Order_Number but what iIwant is to load only those Order_Numbers which have different IssueType.
So, only highlighted records should be loaded into Qlik. Note that IssueType can be same for different orders as is the case for Order_Number 1 and 2. I have to check for the duplicate IssueType for each Order_Number and if there are more than one records with same IssueType for a single Order_Number then I have to pick only one with the oldest date.
Hope, I have made the requirement clear enough but if not please let me know. I need to come up with a solution real quick for this one so any suggestion would be of great help.
Load * Inline
Min(Date_Auto) as Date_Auto
Load * Resident TempData;
Drop Table TempData;