In EasyMorph it's not possible to reference other tables in expressions, however it is possible to bring a value from another table and append it as a new column with the help of Peek transformation. Further, this new column can be used in expressions. The Peek transformation is the most basic data merging transformation in EasyMorph.
Lookup transformation is a close equivalent of VLOOKUP function in Excel. It allows looking up and returning values from another table. Unlike Excel's VLOOKUP besides adding a new column the transformation can also replace an existing column.
Merge another table transformation can be used in more complex cases. It merges (joins) one or more columns from another table, based on whether one or more key fields in the current table match respective key fields in the other table. The transformation can operate in three modes:
See our web-help for the full list of transformations.