Hello kind people of the internet.
I need to compare data from an analysis form vs the data we have in a database, to check if our people have made any mistakes typing data into the database.
Each row have 8 variables (columns) only 1 of them is the same in all of the analysis form, the unique ID. The analysis form have 41 parametres which have been tested for, so 41 rows.
In the database there are 42 total columns and 700+ row because it has all the analysis forms combined.
I have tried to do it with validate package but it can only check 1 column at a time. I need to and entire row with 8 columns with the database and see if all the columns are representet in the database, and if not i would like to know with column doesn't match the database.
Can you help me?