Macro error

[ssubramanian]

Hi,

I have a macro that reads input from a file and searches for keywords from another list. I have attached the macro , I am getting an error while executing it and I am not able to fix it. Could someone help me debug and explain what the error is. I am really new to Alteryx macro , so I am kinda not following the code.

[Inactive User · Accepted solution]

In the action within the macro, update it to point to expression and replace "Keyword" minus the quotes. This will update the batch to change this and search for it. 

[ssubramanian]

Hi Ryan, Thanks for the quick response. Could you please tell me where exactly you made the change. A screen shot would be really helpful. because I am not able to figure it out. I understand that you changed Journal_Desc to Desc but wanted to know where else you make the change because I see that the Keyword is still wrapped in quotes.

[BenMoss]

Take a look at Ryans solution and look at the 'action' tool, you'll see we use the term Keyword as a placeholder, removing the qoutes as we don't want to overwrite these, otherwise our contains function would be...

contains([Desc],Ben)

when it should be...

contains([Desc],"Ben")

[ssubramanian]

Gotcha!!!! Thank you so much Ryan and Ben! :) It was really helpful.