VERIFY CSV DATA DB
Description
Verify CSV data with the result of executing SQL Statement
– Value 1(*):
[DOWNLOADED FILE] if verifying CSV data is downloaded in [VERIFY DOWNLOADED FILE] Keyword
Local file path is defined in [application.properties] if verifying CSV data in local file
– Value 2(*): The SQL Statement to be executed (defined in [sqlStatement.properties]). The result of executing SQL Statement will be compared to the data of CSV file
– Value 3: The index of start column to be verified in CSV file. Default is the index of first column [1]
– Value 4: The index of end column to be verified in CSV file. Default is getting the last column
– Value 5: The index of start row to be verified in CSV File. Default is the index of first row [1]
– Value 6: The index of end row to be verified in CSV file. Default is getting the last row
Example