Trying to filter based off criteria entered in Text Input tool - is this possible?

I'm a bit of a noob to alteryx but trying to give it a go so apologies if this is a silly question.

I'm basically trying to filter my main data by the criteria within the text input tool, I've currently tried to use a Join tool but I dont think this is returning the right data. I know i could use a filter tool but worried that when i have more variables updating the expression will become longwinded - is there any other way to do this?

Thanks

Joe

New Workflow4.yxmd

Interface Tools

Accepted answers

Bren_Spill2

@joewils92 - it appears to be working correctly. When joining like this to filter records I find it helpful to add summarize tools on the L and R inputs, as well as on the outputs. This allows you to look at how unique records are acting as opposed to looking at the full dataset containing duplicates.

You have 12 keys in the R input. If you summarize the J output on the key - you'll see the same 12 records. This should the join is working correctly. Screen shot below of my quick checks:

All comments

Deano478

@joewils92 can you provide some sample data so we can play around with this as we cant access your local file

joewils92

Apologies, i've updated the workflow with sample data below

New Workflow4.yxmd

Bren_Spill2

You have 12 keys in the R input. If you summarize the J output on the key - you'll see the same 12 records. This should the join is working correctly. Screen shot below of my quick checks:

joewils92

Thanks very much, thats very helpful!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703