Multiple column return in Lookup

Mahulima
Mahulima Contributor
in General

Is there a way to return multiple columns from the lookup table in return

I have DS1 and looking up DS 2 and want to return 3 columns from DS2. My final output will be all col from DS1 and 3 cols from DS2.

Trying with Lookup type "All Value" but in this option just getting 1 column in return

Answers

  • Henry Simms
    Henry Simms Administrator
    edited February 3

    You can return multiple lookup columns from the Lookup step in a Workflow by specifying multiple lookup definitions. In this case, it's likely that you'd be using the same lookup criteria for each lookup (in my case below, WHERE EMAILS.VALUE_POSITION = PEOPLE.POSITION), the process can be sped up significantly by creating the first lookup definition and then using the "Copy" button

    to create a copy, which can be edited to alter the name and return column

    image.png
    image.png

    The All Values lookup type will return all the values found in the specified lookup column that match the lookup criteria (rather than e.g. the first value found, last value found, average of values etc)

  • Mahulima
    Mahulima Contributor

    @Henry Simms Thank you so much Henry ! It is working. Many Thanks!

Categories