> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/data-center-3/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/data-center-3/data-center/data-preparation/data-preparation-workspace/profile-summary-pane/suggestions.md).

# 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.

{% hint style="success" %}
*Check out the given walk-through on how to use Suggestions for a specific column and the entire dataset.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2F7lKScxO3EMPojTUq0Qkg%2FSuggestions%20for%20each%20column.mp4?alt=media&token=e23622ae-c711-454f-9012-a900117c8ee8>" %}
***Transforms Suggestions for each column***
{% endembed %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2FzWcMhSKsYeyHAC1kS5gN%2FSuggestions%20for%20Dataset.mp4?alt=media&token=ada0acb3-6de5-476d-a232-4496f2800a76>" %}
Transforms Suggestions for the Dataset
{% endembed %}

* Select a column from the dataset.
* Open the ***Profile*** tab.
* Select the ***Suggestions*** option.
* The ***Suggestions*** will be displayed for specific columns and dataset.

<figure><img src="https://3037103496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2FRJkktsFkhxHrfnI6hKEb%2Fimage.png?alt=media&amp;token=bf898ec0-6f58-494e-9ef8-1e1afb0de43e" alt=""><figcaption></figcaption></figure>

## Applying Suggestions  to a Specific Column&#x20;

* Select a column.
* The ***Suggestions*** tab will display the suggested transform for it.
* Select a transform using the checkbox.
* Click the ***Apply*** option.

<figure><img src="https://3037103496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2F92rCEHNXSdsV11yNWWjK%2Fimage.png?alt=media&amp;token=d9f87f0a-da64-47fb-8d97-ef3c71e95d63" alt=""><figcaption></figcaption></figure>

* The selected transform gets applied to that column.

<figure><img src="https://3037103496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2FD1beLiwdt9lqfzOLAfbg%2Fimage.png?alt=media&amp;token=4004e882-af8a-4789-81a0-f7484b5e53f1" alt=""><figcaption></figcaption></figure>

## Applying Suggestions  to Multiple Columns&#x20;

* Navigate to the ***Suggestion for Dataset*** space under the ***Suggestions*** tab.
* All the columns will get listed with suggested transforms.

<figure><img src="https://3037103496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2Fbh7t8M9xLL4GJnGCwFNm%2Fimage.png?alt=media&amp;token=d8d1dc64-9b61-4ff6-b728-4f36d8b2e63a" alt=""><figcaption></figcaption></figure>

* 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.

<figure><img src="https://3037103496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2FIxK1nGzBAqaMmG5o8vtj%2Fimage.png?alt=media&amp;token=08536ebc-ac7e-41c8-b8a9-cf9f9882d92a" alt=""><figcaption><p><em><strong>Applying Transform to Category column</strong></em></p></figcaption></figure>

<figure><img src="https://3037103496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2F3uVElrVK9nBQR3oFzmq6%2Fimage.png?alt=media&amp;token=a7dc007e-9854-433c-a89a-1dbb59e270cb" alt=""><figcaption><p><em><strong>Applying Transform to SupplierName column</strong></em></p></figcaption></figure>

<figure><img src="https://3037103496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2Fz7s9IiHLRR5HSujoX1wq%2Fimage.png?alt=media&amp;token=de35ffda-0849-47e7-93df-7b51d341073b" alt=""><figcaption><p>Applying Transform to the Description column</p></figcaption></figure>

* Click a common ***Apply*** option provided for all the columns.

<figure><img src="https://3037103496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2FexFwfVDR21Eo1swJ55b4%2Fimage.png?alt=media&amp;token=9c98b7b0-8338-4200-882c-94fcfd56dcb1" alt=""><figcaption></figcaption></figure>

* The selected transform gets applied to those columns.

<figure><img src="https://3037103496-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIctE5LjGWDD6zEdW4vpJ%2Fuploads%2FVkayZ9pTPCaIATQ5HCDE%2Fimage.png?alt=media&amp;token=2d78cd2b-58a4-4510-a927-14091189f568" alt=""><figcaption><p><em><strong>Displaying Transformed Data</strong></em> </p></figcaption></figure>