6 Replies Latest reply on Oct 2, 2020 8:30 AM by user126898

    IDQ - SQL filter to exclude large list of values from a table while profiling

    Anuja G Active Member

      Using a SQL filter in Informatica Data Quality, I know we can filter data from database rows like first_name not equal to 'Tom'.

       

      I have a list of values stored in a .txt file. This list is large (about 200 values) and it might increase in the future. I wanted to know if there is a way using SQL filter or any other way in IDQ tool to reference this list and filter table rows where the value is one among the list values.

       

      I want to use this filter for profiling and exclude values in profiling that already exists in the list.