Performing a Lookup on Worksheets
Effective in version 10.1.1, you can perform a lookup. Use the lookup function to lookup a key column in another sheet and fetch values in corresponding other columns in that looked up sheet.
For more information, see the "Prepare Data" chapter in the
10.1.1 Intelligent Data Lake User Guide.