How to do a VLOOKUP for my below scenario

Please help me on how to do a vlookup on CATALOG_ID/MODULE_ID from dataset A to the CATALOG_ID/MODULE_ID from dataset B, and populate the column NOTACTIVE in the Dataset A as N if the CATALOG_ID/MODULE_ID exists in dataset B...

Dataset A

Dataset B

Thanks

Smrithi

Parse

Accepted answers

DanielvanLeuzen

@smrithiraj there are different ways of doing it, but I would do the following

- Group the catalog_ID from data set B
- Use the join tool to group on Catalog_ID
- Add a formula tool to the left/right output from the join ( depending on how you set it up) and write something like 'not active' to a new field
- use the union tool to combine the left/right output with the joined output

You can see the attached screenshot as a reference

Best,

Daniel

alteryx vlookup.png

All comments

Screenshot 2024-02-23 172232.png

ModuleID.yxmd

apathetichell

What's your expected behavior for English Internal in Course ID 1. This will not match English (Internal) and I assume Primary Param values change depending upon some combination of column A/B in dataset 2?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703