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.

[binuacs]

@Sunithaprdp please check the FindReplace tool setting 

[Sunithaprdp]

Yes now it worked!! 🙂

But I am not getting output in csv format and it is not getting popped up in the respective output folder.

[binuacs]

@Sunithaprdp that means there is an issue with your second directory. It should return some data. please check the below part is getting data 

[Sunithaprdp]

I again mapped second directory to the Worksheet Input folder. I am getting output in excel format and it is not popping out as a text file. Also the output (which is in excel format) is getting copied to the main folder.

[binuacs · Accepted solution]

@Sunithaprdp  please check your output tool configuration

1, you are getting the output in the same folder because the CSVOutputName is given as ""./Output/"+[FileName]+"_Final.csv""

give the full path  by replacing ./Output 

2. getting your output in xlsx format check your output settings

[Sunithaprdp]

Hi,

The configuration seems to be as shown on the screenshots above. 

I am attaching screenshots of how my workflow is showing:

Let me know if this works? Thanks in advance.

[Sunithaprdp]

Thank you so much for your valuable support on this, it is successful!!

[Fcyt999]

To open two Excel files side by side, do the following:

Open the workbooks you want to compare then Go to the View tab, Window group, and click the View Side by Side button. That's it!

By default, two separate Excel windows are displayed horizontally.

To split Excel windows vertically, click Arrange All button and select Vertical:

As the result, two separate Excel windows will be arranged side by side. Thanks to .Avs Series