In Filter -In DB

[Trich]

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. 

[Thableaus]

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,

[Trich]

[Thableaus]

@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,

[Trich]

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

[Thableaus · Accepted solution]

@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,

[Trich · Accepted solution]

Thank you so much!