Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

How to search for a string in one column within another and produce results in a third

Highlighted
6 - Meteoroid

Hi,

 

I am trying to seatch for the Instrument TIC in Column B within the string on Column A. Then if found return the full text within Column A in a new Column C

 

Can you help?

 

Thanks,

 

Roger

Highlighted
7 - Meteor

mwindeler_0-1581947852567.png

 

You can use the contains expression to search for strings within fields.

Highlighted
6 - Meteoroid

Hey,

 

Thanks for the quick response.

 

That query works but I need to actually search the whole population of column A to find if a cell contains Column B rather than the adjoining Cell in each row.

 

How could I do that ?

 

Thanks,

 

Roger

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hello @RDodger,

 

In my case I used a regex tool to be able to better see both numbers:

 

Untitled.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Highlighted
7 - Meteor

mwindeler_0-1581949234703.png

 

You can split into two columns and feed into either inputs of the find/replace tool.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Changed the logic based on your new post @RDodger 

 

You can check it again now

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Highlighted
6 - Meteoroid

That worked. thanks a lot!!

Labels