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,
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 an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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 an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, 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