Solved
How to delete entire line items from an excel sheet by the summed up amount field?
I need to delete entire lines on an excel spread sheet with over 1 Million line items based on the sum of the amount field. Basically, I have one large spreadsheet with I first need to categorize by department name, then vendor name, and delete the lines of expenditures to each vendor if it does not exceed a certain amount. Is there a way to accomplish this on FME?
Best answer by owen
Hello,
View original
Yes, you could use a testfilter to filter out records over a certain amount, and write the remainder out using a dynamic writer.
Owen
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+1Hello,
Yes, you could use a testfilter to filter out records over a certain amount, and write the remainder out using a dynamic writer.
Owen
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.