This action queries records, matching to an input record, from the data source.
|Table||An object to query records from.|
|Keys||The lookup table fields, by which input records and lookup table records are matched.|
|Result Columns||The columns from the matched records, returned as the result.|
Lookup action parameters correspond to the selected Keys.
Result Column values from the matched records.
Here is an example of Lookup action in the Lookup component of Data Flow. This example shows the Lookup action that matches Zoho CRM accounts with the input records by their names and returns the matched Zoho CRM account IDs.