Filter using two Text Box fields

[eduardomarchesin]

Hi team,

I'm trying to get information using two parameters from two differents Text Box. But my workflow does not change the result.

Could you please help me?

Please find attached my workflow, and below some screens:

I have this information:

I have two Text Box,  and I would like to filter the information between 202102 and 202103, but the result remains the same 202101.

Rgds

Eduardo

[TheOC]

hey @eduardomarchesin 

You're very close! your issue is in your action tool, you had told it to replace 'Custom' with whatever gets input into the textbox, that isn't what we want.

What we want is to replace the specific value in the filter, in this case:

I have changed it to replace "202101"

I have also done this to the other one, and uploaded the workflow.

Hope this helps!
TheOC

[eduardomarchesin]

Hi @TheOC 

Thank you very much for your quick answer!

I've done as you mentioned but it is not working yet, I mean, I've replaced both Text Box with 202101. 

Do I need to change anything in the filter function?

After that, the result was changed but with only 1 register, the result should be two registers 202102 and 202103.

*** I've could not open your workflow, my version is previous from of yours.

Rgds

Eduardo

[TheOC · Accepted solution]

ah, yes, one other thing i changed, so they will both change both instances of "202101", so as you have two input/action tools, you need 2 distinct values in the filter.

Set the second value to "202102" in the filter, and then make sure thats set to change in the action tool too!

Also, if you'd like to open mine there is a way (although its a slight pain https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-open-newer-version-yxzp-files/t...)

Cheers,
TheOC

[atcodedog05 · Accepted solution]

Hi @eduardomarchesin 

Here is a work around for downgrading workflows and app

How to downgrade .yxmd(Workflow), .yxmc(Macro), .yxwz(Analytic app) file types

I know images are missing sorry about that 😅

Hope this helps  

[eduardomarchesin]

Hi @TheOC 

Perfect, it is working now.

Thank you very much for your help

Eduardo

[TheOC]

no problem! Glad you got it sorted!

TheOC