Vlookup in Aperture

Wojciech Glowacki

Hi,

Is there a way to do a vlookup in aperture like in excel? I know it can be done somewhat using the join in the workflow but is there an easier way or a function to do so?

Thank you in advance for your help!

Josh Boxer

Yes you want to use the Workflow step Lookup: https://docs.experianaperture.io/data-quality/aperture-data-studio/objects/workflows/#lookup~workflow-steps

There are also Lookup Functions that allow you to match a value in another Dataset, but i think you want the Workflow step to do Excel like functionality https://docs.experianaperture.io/data-quality/aperture-data-studio/objects/functions/#lookup~native-functions