How to get information from CVS file(working like jdbc_streaming) in filter section for enrichment?

[dsakpal (Dipesh Sakpal)]

Scenario: Taking particular value from log file & depending on that value I need to get information from static CSV file.

So we are getting ASSETID from log file. Using that ASSETID I need to find ASSETNAME & ASSETGRP from csv file(mapping of ASSETID & ASSETNAME is already stoared into the csv file). So I just need a 'assetname' & 'assetgrp' from csv.

[magnusbaeck (Magnus Bäck)]

Use the translate filter.

[dsakpal (Dipesh Sakpal)]

Thanks but I have few doubt in my mind about translate filter, they are as below

but if I want to get two fields/values from csv then how do I do that?
My csv file format is like that,
Column ===> ASSETID, ASSETNAME, ASSETGRP

I am getting ASSETID from my log file & retrive ASSETNAME & ASSETGRP from csv in one attempt.

[magnusbaeck (Magnus Bäck)]

You can format the file as

ASSETID,ASSETNAME;ASSETGRP

and extract the asset name and group into a single field and then use another filter to further split it up.

[dsakpal (Dipesh Sakpal)]

Thanks