Create a new CSV file with the differences between two tables

[Maria_Cabrera]

Hi I am in dire need of support to figure out what is happening with my file.

In a nutshell, I’m comparing two csv files and I can’t get the bot to compare whether or not there are duplicates. I’ve attached my files and bot. ANY help is welcomed!

[ppr (Peter Preuss)]

@Maria_Cabrera
Welome to the forum.

I do assume that the csv are already in a datatable and for the duplate deteection all columns are to check.
So have a look here:

[HowTo] - Find Duplicate / NonDuplicate rows - checking all columns - without explicit listing the colnames/index

Introduction In the majority of scenarios duplicated / Non duplicated rows can be identified by a few columns grace to the key column concept. In order to retrieve it, the group by approach helps It can be done e.g. with some nice components from Connect or LINQ In some scenarios all duplicated / non duplicated rows should be detected by checking all columns. Setting up an approach without explicit listing all column names or column index would speed up the implementation. Implementat…

If only a little no of cols are to check if it makes a duplicate then let me know and I can share some other demo with you

[Maria_Cabrera]

Also, for whatever reason I can’t upload my documents with my information

[supermanPunch (Arpan)]

@Maria_Cabrera Since this is your first post you will not be able to upload any files in here , But as the communication and the interaction increases you will have access to upload files.

[Srini84 (Srinivas)]

@Maria_Cabrera

You can upload your required files to google drive and paste your link

Hope this helps

Thanks

[Maria_Cabrera]

Quick consult for you @Srini84 & @supermanPunch I have a excel xlsx file (reference table) and I want my bot to compare the reference table to the data it just webscrapped off a site. Do you have any examples of that being possible?

[supermanPunch (Arpan)]

@Maria_Cabrera Since the table can already be datascraped from the website, you can get it as a Datatable, and the data from the Reference Excel can also be Read as a Datatable using a Read Range Activity. Since both the input data are in the Form of a Datatable, you can use @ppr 's suggested post to get the output you need. If that post isn’t helping you entirely then i suggest you describe your problem in a bit more detail.