Match multiple columns with Lookup Plus
You can match multiple columns using the Lookup Plus component. See the steps below for one possible solution:
- Create a new data flow. This data flow will build a lookup reference dictionary and store it in a package variable.
- Insert a data flow source component.
- Insert the Checksum Transform script after the component from step 2 to create a unique CRC32 value for the match input columns.
- Insert the Dictionary Destination script after the component from step 3. For the key, select the input column containing the CRC32 value. For the value, specify the appropriate reference column. Store the resulting dictionary object in a package variable.
- Create another data flow, which will do the lookup and matching.
- Insert the data flow source with the data that is to be matched.
- Insert the Checksum Transform script after the component from step 6 to create a unique CRC32 value for the required input columns.
- Insert the Lookup Plus component. As the key, specify the input column containing the CRC32 value. In the reference dialog, select the "From Variable" option. Set it to the variable you created in step 4.
Book a Presales Call
Related Articles
Match multiple columns with Lookup Plus
You can match multiple columns using the Lookup Plus component. See the steps below for one possible solution: Create a new data flow. This data flow will build a lookup reference dictionary and store it in a package variable. Insert a data flow ...
Match multiple columns with Lookup Plus
You can match multiple columns using the Lookup Plus component. See the steps below for one possible solution: Create a new data flow. This data flow will build a lookup reference dictionary and store it in a package variable. Insert a data flow ...
Match multiple columns with Lookup Plus
You can match multiple columns using the Lookup Plus component. See the steps below for one possible solution: Create a new data flow. This data flow will build a lookup reference dictionary and store it in a package variable. Insert a data flow ...
Match multiple columns with Lookup Plus
You can match multiple columns using the Lookup Plus component. See the steps below for one possible solution: Create a new data flow. This data flow will build a lookup reference dictionary and store it in a package variable. Insert a data flow ...
Error Message: Columns cannot convert between unicode and non-unicode string datatype
Action: When I am executing a package that includes Lookup Plus Component I get the following error message: Error Message: Columns cannot convert between unicode and non-unicode string datatype Solution: To resolve this issue ...