Tool Enhancements

For this release of Aqua Data Studio 19.5, we have enhanced the Import tools for Excel and CSV files.

Import tools

We have enhanced the Aqua Data Studio Import tool for null values when importing data. The new option to "Ignore rows with all null values" can be enabled under the Options tab inside Data Options.

Excel Import

For Excel and also CSV files a constant value can be inserted during import process. When importing data, under the Format tab select "Constant Value" as a source and introduce some constant value for the expected datatype.