Tutorials for Nexial

The Test Automation Platform for everyone!

View project on GitHub

Database Automation

Section 5: SELECT to CSV / bulk comparison

Compare Query Results

Compare1 data

Compare1 script

Compare Query Results, Take 2

Compare2 data

The first two comparisons ran as expected - no differences found:
Compare2 nodif

However the last comparison shows multiple variance between the two CSV output:
Compare2 nodif

I should say that this is also expected since the underlying queries for them are different.

Compare Against Baseline File

Compare3 data

Compare3 script

Compare3 compare

Compare3 compare with match