Trying to remove lower amount

6 posts / 0 new
Last post
CFE4130
Offline
Joined: 08/05/2019 - 12:59
Trying to remove lower amount
Files: 
Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57
Hi CFE130

Is this for the entire file or certain groupings. If you want to obtain the lower amounts you can use the Top Records Extraction (it also does the bottom records) and extract the records that way. If you are trying to remove them from your file then you could add on a record number field, do the bottom record extraction and then do a join based on the record number with the original file to remove those transactions using the no secondary match option.
CFE4130
Offline
Joined: 08/05/2019 - 12:59

It would be based off of certain groupings such removing the lowest amount for each staff member for each date.

Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57
So in this case you want to add a record number field to your source file, you can use the @Precno() function to add the field.

You then would run the top records extraction with the type being Bottom Records, Bottom Records for would be the amount field and the grouping would be staff member and date.

You would then take your main file and join it to the bottom records you created by the record number field and select no secondary matches which will remove all the items from the bottom records file from your source file. Make sure you validate the bottom records file to make sure that you are getting the items you expect.

Good luck in your project.
CFE4130
Offline
Joined: 08/05/2019 - 12:59

Brian,
 
I finally had time to attempt this today. Your explanation made it simple. Thank you so much for your help. 

Brian Element's picture
Brian Element
Online
Joined: 07/11/2012 - 19:57

That is great, thanks for letting me know.