Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

RDodger
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

6 REPLIES 6
mwindeler
7 - Meteor

mwindeler_0-1581947852567.png

 

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

RDodger
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

afv2688
16 - Nebula
16 - Nebula

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

mwindeler
7 - Meteor

mwindeler_0-1581949234703.png

 

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

afv2688
16 - Nebula
16 - Nebula

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

RDodger
6 - Meteoroid

That worked. thanks a lot!!

Labels