topic Re: In Filter -In DB in Alteryx Designer Desktop Discussions

In Filter -In DB

Trich — Mon, 22 Apr 2019 18:55:27 GMT

Hi,

I am using the filter IN-DB with a date criteria feeding a Connect In-DB. I have had to repeat the filter with the same date to different databases or Connect In-DB. Is there away that this can be done with one filter to multiple Connect In-DB?

Any help would be appreciated.

Re: In Filter -In DB

Thableaus — Mon, 22 Apr 2019 23:59:19 GMT

Hi @Trich

Could you please provide printscreens of what problems you're facing?

I don't seem to get what issue you're having and a picture of the situation would be better to understand.

Cheers,

Re: In Filter -In DB

Trich — Tue, 23 Apr 2019 13:45:55 GMT

Re: In Filter -In DB

Thableaus — Tue, 23 Apr 2019 13:52:43 GMT

@Trich

So let me get this straight: you'd like to use a single filter tool to all of your connections?

The filter tool accepts only a single input.

The picture doesn't say much about the problem itself, the only thing I can see is a filter tool with a hardcoded Date.

Cheers,

Re: In Filter -In DB

Trich — Tue, 23 Apr 2019 16:54:04 GMT

Thanks! is there away to feed a hardcoded date in to all the filters from something else?

Re: In Filter -In DB

Thableaus — Tue, 23 Apr 2019 17:00:02 GMT

@Trich

Yes, now I do get what you're saying.

You could use a Workflow user constant.

Manually add the constant in this menu.

To reference it in the other filter tools: %User.ConstantName%

So when you need to update the date, you just need to change the value in this menu, not in all of the tools.

Cheers,

Re: In Filter -In DB

Trich — Tue, 23 Apr 2019 18:16:21 GMT

Thank you so much!