Designer - Lookup of field from other data source

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

Transformation

Accepted answers

LadyNaureen

Thank you all for prompt response and resolution.

This is really a great community 🙂

Regards,

LadyN

All comments

mceleavey

Hi @LadyNaureen ,

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

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.

LadyNaureen

Two files attached.

COURSE.CSV

STUDENT.csv

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703