Macro error

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.

Alteryx - Q4 - macro_SS.yxmc

Alteryx - Q4_SS.yxmd

test_input.xlsx

Macros

Accepted answers

unknown

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.

Alteryx - Q4 - macro_SS.yxmc

All comments

unknown

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.

Alteryx - Q4 - macro_SS.yxmc

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703