Action Update Value Replace a specific string does not work for Query Input Data

I'm using a directory, filled with text files that reflect historical records for a repeating process, as a searchable area. Each week another instance of this process occurs and we're creating a text file of all of the instances. This is a macro where other users can enter in the Agent ID and get results showing every instane where a person was on the file. The input on my workflow search through this folder and identifies every instance where a specific person was on the file [Agent ID].

I'm using the Action tool to replace the default value of 0000000001 and am getting no results, using an Agent ID that I know is on one of these files. When I manually enter that same ID into my filter tool and disconnect the Action tool, I get expected results.

What the he!! am I doing wrong?

Thanks, in advance

Rob

ADF File Research Tool.yxzp

Workflow

Accepted answers

Thableaus

@rob_lawson

Change Basic Filter to CUSTOM FILTER. Select the EXPRESSION. Replace ONLY the agent ID number. See pictures below:

Run it as an app by clicking on the magic wand. Don't forget that as well.

Cheers,

All comments

Avinash_K

If you are using under operand , operand-value to be replaced , then no need to specify the option to replace the string. Just remove that option and filter should work fine .

rob_lawson

Thanks but that's no bueno.

I'm attaching a sample output from the Data Cleansing tool immediately prior to the Filter where I'm performing the replace function so you can run this WF if you want.

Here's what my Action config panel looks like, based upon your suggestion, but still yielded no results:

Action Replace tool.png

Output data.yxdb

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703