Vlookup and replace the value

[Zan_1]

 

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 

[rzdodson]

@Zan_1 here is one way to solve this.

[Zan_1]

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]

Slightly different now that you have changed the requirements. What I would recommend is:

1. Create a unique identifier (UID) that combines the Batch Number and UID fields then Join those two tables on the UID
2. Drop the UID and Student ID fields from the "bad" table. Keep the ones from the table that has the correct values.
3. Use the Join tool to then move the fields to where you need them for your final output.

[Zan_1]

Can you please send me the alteryx work flow, it’s difficult to conceptualise 

[cjaneczko]

How about this.