How to Perform a Lookup Based on Concatenated Fields

In this video, we will show you how to perform a lookup based on concatenated fields. You might want to do this if your data comes in with separate parts and you need to combine them into an 'orderID', for example, and you'd get a value based on that order. eOne Solutions will show you how you can achieve this by combining two source columns into one and using that in a lookup. If you'd rather read the help article that goes along with this, click here.