Cleanse assets

Back Next

Rules and guidelines for test data

You can import data to the test panel in the cleanse asset and save the test data in the asset configuration.

Consider the following rules and guidelines when you import or enter test data:

The import option supports CSV and Microsoft Excel files.

You can import up to 200 consecutive rows of data from a delimited file. You can specify the row at which the import starts.

Before you import, check the file for column headings. If the first row in the import file contains column headings, start the import at line 2 or lower.

The Maximum string length property applies to the data in the test panel in addition to the strings that the asset reads and writes at run time. When you test the asset, import or enter a string on each row that does not exceed the value on the property.

You can set a maximum string length of 10,000 characters. The default maximum length is 255 characters.

If you import a CSV file that contains multiple columns or uses a text qualifier, verify that the file uses a delimiter or a text qualifier that the Secure Agent recognizes. By default, the Comma option is the delimiter for the column data. By default, the No quotes option is the text qualifier for the data. You can update the delimiter and text qualifier characters when you select the data to import. The Delimiter and Text Qualifier options are not required when you import a Microsoft Excel file.

The Secure Agent saves the data that you import to the asset when you save the asset. If you change an option in the asset configuration, you may lose any unsaved test data.

Testing a cleanse instance

Download Guide

Watch

Comments

Cloud Data Quality Homepage