Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Vlookup and replace the value

Zan_1
6 - Meteoroid

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 

IMG_6733.jpeg

 thank you for all the help 

 

5 REPLIES 5
rzdodson
12 - Quasar

@Zan_1 here is one way to solve this.

 

Solution.png

Zan_1
6 - Meteoroid

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

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
6 - Meteoroid

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

cjaneczko
13 - Pulsar

How about this.

 

image.pngimage.pngimage.png

Labels
Top Solution Authors