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?
Page 1 / 1
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