Simple Filtering

        Here we are going to pull out our desired records using filtering technique. The input data which has countries and currencies data is given as below: 

          The text file is taken as an input through the tFileInputDelimited component and the tFilterRow is deployed to filter the input rows and produce the output which can be viewed by tLogRow component or get as an output file using tFileOutputDelimited component. 

Row separator-  "\n" means next line i.e. each record is separated by next line.

Field separator- "," means each field is separated by comma separator or delimiter 

       The above filter setting figure tells us that the currency value equal to euro - "EUR" should be filtered out and rest of the records should be rejected. 

         That produces the following output: 

                                     Thanks a lot for Visiting and come again.