Is there any transformer equivalent to COUNTIF or COUNTIFS excel functions in FME.
I have a very large csv file that is not openable in excel that i need to perform a count on certain attributes that have numerical values. e.g Count the total number of values between 1-10 etc
I am currently using expressionevaluator transformer where it sets an attribute to 1 if condition is met otherwise 0. then i use statistics calculator to sum up the total.
wondering if there is any quick and simple way to do that.
I have two attributes that i need to check with 5 different conditions
Best answer by takashi
View original