Update tool using one prompt to update 2 values in a filter

Hi all,

I have a filter on a Rate of Exchange table and need an update tool to update both of the values of the dates in the filter.

The filter criteria are as follows:

ToDate([dtActiveFrom]) < "2023-06-30" and [dtActiveTo] > "2023-06-30"

I want the user to select only one date from the Date Tool, but update both date values in the filter. How do I do this?

Interface Tools

Accepted answers

binu_acs

@andy_vasey another way

Date_090623.yxwz

All comments

Clifford_Coon

Hi @andy_vasey ,

You can use one update tool if the replace values are the same, by using a formula.

The formula will update both instance of 2023-06-30 in the filter.

update.yxwz

mceleavey

Hi @andy_vasey ,

there are a couple of ways of doing this. First, you can create a field in a text input tool or a formula tool and simply overwrite this by connecting the Date tool and overwriting the value. Then in your filter, change it to:

ToDate([dtActiveFrom]) < [Date] and [dtActiveTo] > [Date]

The other way is to attach the Date tool to the filter itself and use the Action tool to overwrite the values:

I have attached an example of this.

For further reading, you might find the following link useful:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Tool-Mastery-Action/ta-p/35500

I hope this helps,

Action Example.yxwz

binu_acs

@andy_vasey another way

Date_090623.yxwz

andy_vasey

Many thanks for both replies. All good now.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703