Merging two data sets

Alessia11900

Dear Alteryx community,

I would like to ask for your kind assistance/expertise in creating the following workflow:

I am looking two merge two listings but am not sure how to go about it.

I have created a workflow from a data set that has given me a long list of invoice numbers that fit a particular set of criteria.

I would like to filter the original data set by this list of invoice number that have been identified, ultimately creating a listing with all the columns from the original listing but only including the invoice numbers identified.

Many thanks!

Datasets

Common Use Cases

Transformation

Database Connection

Accepted answers

ShankerV

Hi @Alessia11900

Have created a sample use case to explain the solution 1.

Solution 1:

Dataset 1: Input

Dataset 2: Input

Output:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

All comments

ShankerV

Hi @Alessia11900

We can achieve this by many ways.

Solution 1: To use the join tool

Solution 2: To use the find and replace tool

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

ShankerV

Hi @Alessia11900

Have created a sample use case to explain the solution 1.

Solution 1:

Dataset 1: Input

Dataset 2: Input

Output:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

ShankerV

Hi @Alessia11900

Have created a sample use case to explain the solution 2.

Solution 2:

Dataset 1: Input

Dataset 2: Input

Step 2:

Step 3:

Step 4:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703