Hi,
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?
+7
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])
FROM [SheetName$$]
GROUP BY [ColumnName]
HAVING COUNT([ColumnName])>1
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:
Kind Regards,
Ashwin A.K
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.