Suggestions
Avail auto-suggestions to display a customised list of the related transforms for your targeted data.
The Suggestions option displays a tailor-made list containing suitable transformations from the available comprehensive list based on the data type of the selected column. These auto-generated Suggestions help the users to clean their desired dataset in a faster and more accurate manner.
Check out the given walk-through on how to use Suggestions for a specific column and the entire dataset.
Select a column from the dataset.
Open the Profile tab.
Select the Suggestions option.
The Suggestions will be displayed for specific columns and dataset.
Applying Suggestions to a Specific Column
Select a column.
The Suggestions tab will display the suggested transform for it.
Select a transform using the checkbox.
Click the Apply option.
The selected transform gets applied to that column.
Applying Suggestions to Multiple Columns
Navigate to the Suggestion for Dataset space under the Suggestions tab.
All the columns will get listed with suggested transforms.
Select a Column and specific Transform (the user can select multiple transforms).
Select a transform using the checkbox. As shown in the given images for the Category, SupplierName, and Description columns.
Click a common Apply option provided for all the columns.
The selected transform gets applied to those columns.
