Vlookup and replace the value
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Zan_1
6 - Meteoroid
11-17-2023
05:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
i am trying to create a table that basically replaces the value in table 2 and generates a new table with table 1 corresponding values- also final table should have students
id in text format
please see attached image
thank you for all the help
Labels:
5 REPLIES 5
rzdodson
12 - Quasar
11-17-2023
06:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
11-17-2023
06:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Blodi
thank you for your reply, however I have edited the question- the student id is repetitive with different batch numbers
would the solution still be same as yours
thank you
rzdodson
12 - Quasar
11-17-2023
06:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Slightly different now that you have changed the requirements. What I would recommend is:
- Create a unique identifier (UID) that combines the Batch Number and UID fields then Join those two tables on the UID
- Drop the UID and Student ID fields from the "bad" table. Keep the ones from the table that has the correct values.
- Use the Join tool to then move the fields to where you need them for your final output.
11-17-2023
06:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you please send me the alteryx work flow, it’s difficult to conceptualise
cjaneczko
13 - Pulsar
11-17-2023
08:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
