Data preparation toolsare specifically designed to transform raw data into a usable format for efficient data analytics. This involves tasks like removing null values, standardizing data entries, and eliminating duplicates. While Excel’s features can address some of these issues during data entry, the...
To improve the original Engine performance (make AMP write a YXDB file created with the original Engine), go to theOutput Data-Configurationmenu, where you have the option to create a version of the YXDB file compatible with Designer 18.1 and older. The Output tool behaves differently with r...
Correcting missing data: Inputting missing values, deleting rows or columns with a high percentage of missing data, and using interpolation to estimate missing values Converting data types: Changing strings to numeric values, converting datetime formats, and converting categorical data into numerical repr...
less efficient analysis. rules around deduping depend on a company's desired outcome. for example, if a customer submitted different emails on different pages of a website, a conservative approach would eliminate only rows of data where every field is an exact match. remove irrelevant ...