How to compare a csv file and excel file to identify duplicates?

[Sunithaprdp]

I am new to Alteryx. I wanted compare a csv file with 136 characters with an excel worksheet to identify lines with common identifier. The output should be similar to the csv input file. But it should contain only the details of common identifiers. Please help. I am attaching samples.

As per the sample : there is a common identifier between csv SAMPLE and excel sample that is '00012-0123-45 with name ABCDE. So the output should be the eliminated csv file with no second line that is:

QTY0001205789622021STUVW00000001.23400000000000123.0000000000009999.99000000020000000002379.670000000000000.000000000002345.78.

The text file should only contain first line of SAMPLEs.

[Sunithaprdp]

Yes , likewise there will be multiple files with a unique number to each programs. Here with reference to the examples given we should have 4 output with the naming convention:

1Q21 AB PROGRAM FINAL_12345/ 1Q21 AB PROGRAM FINAL 56798/ 1Q21 CD PROGRAM FINAL _12345/ 1Q21 CD PROGRAM FINAL _56798

[Sunithaprdp]

Sure I will run and then let you know the results.

[binuacs]

@Sunithaprdp made some changes in the workflow, so that you will not get the extra fields in the output files

[Sunithaprdp]

Thank you so much, I will run this in some time and message the result. Thanks a lot!

[Sunithaprdp]

I am getting an error corresponding to the second icon of both text and excel workflows. I mapped path corresponding to the first directory tool for each respectively.

I am getting an error corresponding to 'Find Replace' Tool

I am getting an error corresponding to the output icon after mapping the desired output location to the formula icon.

Could you please advise on the next action to be taken care off?

Thanks in advance!

[binuacs]

@Sunithaprdp please make sure the direcotry tool has the correct path given, What is the output you are getting from the two direcotires ? are you seeing any output like filename, full path etc?

[Sunithaprdp]

The directory tool is mapped with correct location, still I am receiving this error:

[binuacs]

@Sunithaprdp can you check your find and replace has the below options selected

[Sunithaprdp]

Hello,

I checked, my tool does not have those options . It is blank. What is the next action that I should take ?

Looking forward to your advise.

Thanks in advance!

[Sunithaprdp]

When I run, I am getting an error like 
No Fields selected to append.