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?
Thank you for your response. Essentially this is a not an event its company commission data in csv format. The problem I'm facing is that three field values of the companies are different but they are in essence the same company.
I cannot change the source as we receive it, but I would like to make sense of it before I output to elasticsearch.
Thank you I believe this might do it. Apologies I could not be clear enough, I will rely the example.
I have one company called ABC, I receive 100s millions of rows of commission statements. Some providers call company ABC, another name like XYZ or DEF. I need to take those values and call it company ABC.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.