Trying to remove lower amount
CFE4130
Forums
So in this case you want to
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.
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.
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.