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 using a join tool will solve your problem. If you provide some sample data we can help you on this.

[Sunithaprdp]

Yes, I have provided a sample csv and sample excel worksheet. Also has mentioned the desired output. I have edited my question. Now would this be helpful to provide a workflow that suits the output. The output should be in .csv format

[binuacs · Accepted solution]

@Sunithaprdp you need to take the common fields from the excel sheet and check against the .csv fields using the below filter formula 

Contains([Field_1], [NAME]) && Contains([Field_1], [IDENTIFIER])

[Sunithaprdp]

if then do we get an output in .csv format with same characters?

[Sunithaprdp]

When I tried, I am getting desired output in an excel sheet. How to get the same in text like SAMPLE?

[binuacs]

@Sunithaprdp you need to output your result into a .csv file

[Sunithaprdp]

When I replaced with my original files I got error like this. Could you please advise what to do?

[binuacs]

@Sunithaprdp change your append tool setting like below

[Sunithaprdp]

I tried that, but somehow I am not receiving desired output..Dont know exact issue 😞