I'm trying to build a process for which the bot Check a column and trow an error if:
in a column there are any duplicate data
in some line in that specific column an information is missing.
I tried but is not catching the duplication error. Any ideas?
Hi @zeno gALLI ,
The way I would approach this is by connecting to Excel like it were a Database and leverage the SQL operations to my advantage.
SELECT [ColumnName], COUNT ([ColumnName])
GROUP BY [ColumnName]
Then you can check if the DataTable is empty, if so then there are no issues, and if it contains data, that means you have to Throw an exception: