I'm using the download tool to pull down information from an API connection.
I'm able to use a text input field to filter by county - but what do I need to change to filter by more than 1 county at a time?
New to Alteryx so any help is much appreciated!
Hello, @Bigdog1923 perhaps your api Is able to receive multiple counties by a comma separated string? county1, county2, county 3
If so you can concatenate your counties using the summary tool and renaming the field to county
The other option would be to send multiple requests by the counties you want to download data from. Each row would be a request to the api.
Have a fantastic day!
Hi @Bigdog1923 ,
I assume you have a list of counties to use as a filter and apply it to the downloaded data (which has [county] field) as below.
Data from Download Tool
County | Text |
a | abc |
b | bcd |
c | cde |
d | def |
Filter Conditions
County |
a |
c |
Expected Output
County | Text |
a | abc |
c | cde |
In this case, you can use Join Tool as a filter.
I hope this helps. Good luck.