So I was working with the List Lookup transformation to convert country names to country codes, for example, United Kingdom to UK. Because the list was long and typing all the names one by one would have been tedious, I found out that half of the work can be easily eliminated by right clicking the List Lookup transformation object and selecting Fill Lookup List with Unique Input Values.
What this does is that it automatically populates/fills List Lookup’s Source Value column and all that’s left to do is to fill in the Destination Value column.
Picture for reference:
