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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Creating Macro To Search String for Specific Values

Atom

I have tried to create a macro that searches strings for specific value. I know that this function works when not set up as a macro but I would like to be able to set this up for repetitive use. I have a start to it but don't know why I can't get it to finish and pull out the text in the end. This is the first macro I have ever tried to create and would really like some assistance on what I need to do in order to make it work. I will attach what I have so far.

Alteryx Certified Partner
Alteryx Certified Partner

Could you explain why the find and replace tool wouldn't offer the functionality you require?

Alteryx Certified Partner
Alteryx Certified Partner

@enelson,

 

I had created a "contains in-list" macro for another user and placed it into the gallery.  I think that you could learn from the macro (https://gallery.alteryx.com/#!app/Contains-In-List/5a5903fda18e9e2508e5ae0d) and modify it for your use (or use it as-is).

 

Please let me know your thoughts.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Atom

The Reason Find & Replace doesn't work is because I am looking for which field a string exists as well as a row to match. The Find & Replace tool (to my knowledge) does no offer that much functionality.

Atom

I was able to figure out the issue. I didn't realize that you could change settings to be able to view messages from macros which helped me narrow down where the issue was occurring. The goal of this macro is to be able to tell someone who is unfamiliar with a database if a string exists and which field and row that string exists. DISCLAIMER: This will add computing time which is extremely noticeable for larger databases that are over 1 GB. This is for investigative purposes to help someone who is not familiar with a database. 

Labels