Checking if a column contains data from another column

Probably a fairly question but looking for something to a vlookup. Checked some other articles but could not find exactly what I was looking for.

Have attached some sample data to show what I am trying to do.

Basically I have two columns of data which should have the same data in them. I need to check that they do and if there are any differences investigate them. To do this I usually use the vlookup in my sample.

Would there be any way to replicate this in Alteryx?

Thanks

Alteryx query.xlsx

Accepted answers

JosephSerpis

Hi @BillyL14 I mocked up a workflow let me know what you think?

Column_Check_25082020.yxmd

vizAlter

Hi @BillyL14 — You can do it through a Join tool only, and through "Find Replace" tool as well.

Please check the attached solution as I have created both the methods:

(Attached the files again.)

Check if available in another data.yxzp

Check if available in another data.yxmd

vizAlter

@BillyL14 — Two ways -

(1) select the tools which you want to put in the comment box, then right click >>> "Add To New Container".

You can configure the comment windows once you select it.

2) Go to "Documentation" tab >>> Drag "Tool Container" to the canvas (your workflow) >>> now drag the tools from your workflow which you want to keep in it.

If it resolves your query please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution. Thank you.

All comments

JosephSerpis

Hi @BillyL14 I mocked up a workflow let me know what you think?

Column_Check_25082020.yxmd

vizAlter

Hi @BillyL14 — You can do it through a Join tool only, and through "Find Replace" tool as well.

Please check the attached solution as I have created both the methods:

(Attached the files again.)

Check if available in another data.yxzp

Check if available in another data.yxmd

BillyL14

hi @vizAlter

would you mind sending again, I cannot open it, thanks

BillyL14

@JosephSerpis thanks, I'm just going through it at the moment, bit more complex than any of the workflows I have worked with before

BillyL14

Thanks very much for your replies. I am going through those workflows and trying to understand them a bit better. I have a similar type of data attached, would it be possible to run this through the workflow as well? I need to keep the columns with the amounts and have the "check" and "ok" columns next to it. I'd just like to compare how this file goes through the workflow compared to the other file I had earlier.

Thanks again

Alteryx query 2.xlsx

JosephSerpis

Hi @BillyL14 revised the workflow with the new data. Alteryx by default does not allow for same column names and will rename a column to make unique hence one of the amount has been renamed to amount2

Column_Check_25082020.yxmd

vizAlter

@BillyL14 — Please check the solution attached!

Check if available in another data__newData.yxmd

Check if available in another data__newData.yxzp

vizAlter

Hi @BillyL14 — Hope the given solution is good.

If this post assists in resolving the question, please mark it "Like", or "Solved" if it resolves the question. This will help other users find the same answer/resolution. Thank you.

BillyL14

hi @vizAlter

Sorry, fairly last week so didn't get a chance to go try it yet, will let you know, thanks

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335