Designer - Lookup of field from other data source

[LadyNaureen]

Dear Community Members

I need your expert advice on following:

A CSV data file say STUDENT is being used as INPUT and we have to perform a transformation on COURSE_ID column of this file and add new column COURSE_DESC using this field. 

The transformation logic is that there is a separate  COURSE CSV, which has COURSE_ID and COURSE_DESC columns. 

We tried to use FORMULA control on COURSE_ID field but it is not giving option lookup and adding a new field. 

Can you please help us to resolve this blocker for us.

Thank you. 

Regards,

LadyN 

[mceleavey]

Hi @LadyNaureen ,

Can you post your data or mock data so we can help?

M.

[mceleavey]

Hi @LadyNaureen ,

the answer is the join tool, using the COURSE_ID field as the key on which to join.

If you post your data I can build it for you.

You can click HERE to read about the join tool.

M.

[LadyNaureen]

Two files attached.

[mceleavey]

Hi @LadyNaureen ,

thanks for that.

I've attached the workflow for you.

The input tool needs to be ";" separated:

Hope this helps.

M.

[LadyNaureen]

Thank you for prompt resolution mceleavey 

I have used the JOIN and could see the OUTER JOIN icon but on clicking it, nothing is happening. The concern is if COURSE ID is not found in COURSE file then record should not disappear but should be there with NULL COUSER_DESC.

[atcodedog05]

Hi @LadyNaureen 

Based on your scenario, my suggestion would be to use Find&Replace tool which works like excel (vlookup i,e does a left outer join.)

There resource on it : https://community.alteryx.com/t5/Interactive-Lessons/VLookUps-with-Designer/ta-p/80201 

hope this helps 🙂

[LadyNaureen · Accepted solution]

Thank you all for prompt response and resolution. 

This is really a great community 🙂 

Regards,

LadyN

[atcodedog05]

Hi @LadyNaureen 

Hope your issue get resolved 🙂