Hi Mark,
Since you have a support case open for filtering we can further work on this through that medium. I will post the resolution to here once the support case is closed.
Resolution:
There is currently a defect open to fix the filter on the seedlist filter in Datamaker. If you wanted to use this feature, a workaround is to use custom filters.
The maximum of distinct values should depend on the table and column being profiled.
For example, assume that columnA in tableA has 5000 distinct values and I want to create a custom filter with the string ‘Mummy and Daddy’.
We should use 5000, rather than the default of 50.
Doing this resolved Mark's issue.
The custom filter is limited as it would only allow you to filter based on the data that is shown on the transformation map.
In the below example, we provided you with the mappings between 'Column Name' as seen in the main transformation map and the corresponding name like 'tcd_datatype'.
So we have the following:
We want to keep nvarchar types:
So we end up with:
Best regards,
Taylor