Data validation in sql table

Help Studio
, , , , ,
1

Hello, is there any data verification in the columns?

We have a program that processes/parses invoices and inserts some data from them into a table. Such as amount /vendor etc .

But sometimes, because of changes, the process breaks down. And the data is parsed incorrectly. And as a result, it is written to the database incorrectly.

My idea is to automate the check, and for example, process some invoices and compare these data. Just for example, if the table contains a row with certain data (which I will first write down from the invoice), then compare it. If everything is fine, the data matched, then the test is successful; if not, then it is not successful.

Maybe there is some kind of guide that is approximately similar to my task? :slightly_smiling_face:

Regards.

2

Hi @Wallname ,
The data to compare with you can store in an excel file.

In the process first read the row from the datatable and store it in a variable then do read range for the excel file and store it in a datatable.

Now read that datatable and match the variable data you extracted if it matches print - Successful or else print - Unsuccessful.

Thanks & Regards,
Shubham Dutta

1 Like
3

Thank you, I will try.

Regards!