How to do a VLOOKUP for my below scenario

[smrithiraj]

Hi

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

[DanielvanLeuzen · Accepted solution]

@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

[nagakavyasri]

@smrithiraj 

[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?