community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

I need a loop in Alteryx

Alteryx Partner

here is the use case: I have to tables (let's name as table 1 and table 2). In table 1, there is a column named item with many strings, for example "TRIVITRON HEALTHCARE PRIVATE Hitachi LIMITED". Table two is a brand table with only one column named brand (for example "Hitachi"). What I wanna do is to find out brand in my item column in table 1.image.png

 

for example, if you can find "Hitachi"(or some other brands name in table 2), then return ''Hitachi" in a new column in table 1; if not, leave it as blank.

 

the problem for me is there are too many brands need to compare, so I need a loop to figure it out.

Looking forward to any possible solutions you guys offer to me and thanks so much

Quasar
The find and replace tool will do a lookup based on a partial field. I believe this is what you’re looking for and you don’t need a “loop” as you described.
Asteroid

I think this will accomplish what you are trying to do. Let me know if you have any questions. 

Alteryx Partner

thanks so much. That is exactly what I need, yes,yes,yes!!!!  Thanks again!!

Alteryx Partner

thanks so much. I didn't know this tool before. your reply helped me a lot. Thanks again

Labels