Could someone please let me know what filter plugin or process I would need to do to change a field value.
By this I mean I have a column that I want to input via csv, I am good and using the filter csv plugin and then the mutate command to change the data_type.
However my challenge is I have three field values in the data that are basically "field1" , "field2", "field3" but in essence they are the same value that I want to aggregate.
What can I do to change them to the same value at the filter stage, like an if then statement or something?
Appreciate the help