Question

Loading CSV codes into TestFilter

eric_armitage
Rank
Badge +2

I have a list of codes (over 100) in a CSV and want to use a test for each code in a TestFilter. Is there a way to load them all at the same time rather than cutting and pasting individually?

3 replies

ebygomm
Rank
Userlevel 1
Badge +10

Do you need to use the TestFilter? If it's as simple as testing an attribute for a code, you could use the AttributeFilter, this will allow you to import the codes from the csv

eric_armitage
Rank
Badge +2

Thanks but some of the codes are not an exact match so i need to also use operators like "Begins with" or "Contains regex". I've just had a quick look and I don't see any option to do that with the AttributeFilter

ebygomm
Rank
Userlevel 1
Badge +10

Thanks but some of the codes are not an exact match so i need to also use operators like "Begins with" or "Contains regex". I've just had a quick look and I don't see any option to do that with the AttributeFilter

I'd probably still try and use the attribute filter, anything to avoid having to write 100 test statements! So find some method of adding the code as it's own attribute to the data, and then use the attributefilter on that. e.g. you could use an inlinequerier to join the code to the attribute that contains the code, then use the code for your filter.

Reply


Community Stats

28,670
Posts
109,365
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.