Designer - Lookup of field from other data source
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Two files attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @LadyNaureen ,
thanks for that.
I've attached the workflow for you.
The input tool needs to be ";" separated:
Hope this helps.
M.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you all for prompt response and resolution.
This is really a great community 🙂
Regards,
LadyN
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
