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!

[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 · Accepted solution]

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