Hi all,
I joined two files together, then I created a formula to change a fee to zero. Now I'm "union-ing" the new data set with the original data (which contains more records) but I want to filter out the duplicates. I know that the fees with zero have to stay, but how do I take out the other ones?
The data is confidential so I can't share the files.
Thank you in advance!!
Solved! Go to Solution.
You can use this tool "Unique Tool" to filter out any duplicated in the data.
Select the fields you want and this tool filters out the duplicates based on that combination.
Let me know if this works
Additionally, if you always want fee = 0 to be selected over you can sort the data ascending on fees and then use unique. Refer the below workflow.
Workflow:
Hope this helps : )
If you change your workflow to look like this, you avoid getting duplicates in the first place.
The items that match from both lists come out the J input. The L input contains the records from the first file with no matches in the second. Simply Union the two outputs and you'll have the output you're looking for.
Note: This assumes that each of the input lists has no duplicates internally.
Dan
