Alteryx VLookup

Hello All!

I have a macro that looks up the country in my text data input and populates 'Payment Terms as per policy' against the country in the input data file. However, I'm trying to run the render function and it is not working for me. Would be great if anyone can go through my macro and point out the error. Attaching my files here.

Thanks,

Madhur

Workflow - Vlookup - Payment Terms.yxmc

Country Data.xlsx

Macros

Accepted answers

Raj

are you looking at something different
please find the flow attached.

Payment Terms.yxmc

All comments

Raj

Not able to run your Macro as there is something missing.
please share the zip file of workflow.Also why are you not using Find and replace tool or join tool to easily vlookup the data.

Madhur12

Try if this attachment works.

I don't want to find and replace but find and append a column next to the name of the country. If there is no match, it can leave it blank. Thoughts ?

Thanks,
Madhur

Payment Terms macro.yxmc

Raj

appending an field is also possible by find and replace which is quite easy way.
Although will check the Macro attached.

till time give a try to find and replace this is a easy way according to me.

Qiu

@Madhur12
As @Raj mentioned, there are some files and data are missing in your attachment.
Can you use the Function "Export Workflow", so we can take a look?

Madhur12

@Qiu @Raj Here is the exported workflow for you guys to look at!

I tried to use find and replace and the append but it didnt work for me. Please let me know if you can figure a way out!

Thanks a lot!

Madhur

Payment Terms.yxzp

Raj

sorry but i am still not able to understand what you want to achieve as you are being self-appending the complete data.
it would be great if you could tell the expectation to achieve in output.

do you want to bring the days column from master list or something else?
@Madhur12

Raj

are you looking at something different
please find the flow attached.

Payment Terms.yxmc

Madhur12

Thank you so much @Raj. This worked.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703