> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/data-center-4/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-4/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://content.gitbook.com/content/TEE47Mdie26Zlpy6Ko2H/blobs/Goc57TAzDAvNzs1EZXca/image.png" 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://content.gitbook.com/content/TEE47Mdie26Zlpy6Ko2H/blobs/KY6XCZNNaYTvFlvxDzc4/image.png" alt=""><figcaption></figcaption></figure>

* The selected transform gets applied to that column.

<figure><img src="https://content.gitbook.com/content/TEE47Mdie26Zlpy6Ko2H/blobs/dsrbYuZovUcxzgx1tdfl/image.png" 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://content.gitbook.com/content/TEE47Mdie26Zlpy6Ko2H/blobs/NYWbgWvsnb6qtlICtJgn/image.png" 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://content.gitbook.com/content/TEE47Mdie26Zlpy6Ko2H/blobs/up1hjI2ZoRQMWMOQivg1/image.png" alt=""><figcaption><p><em><strong>Applying Transform to Category column</strong></em></p></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/TEE47Mdie26Zlpy6Ko2H/blobs/RC7Lb4Hg8dbCpnXvS9FQ/image.png" alt=""><figcaption><p><em><strong>Applying Transform to SupplierName column</strong></em></p></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/TEE47Mdie26Zlpy6Ko2H/blobs/v2jNlhLYZiW4fbjBHv7z/image.png" 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://content.gitbook.com/content/TEE47Mdie26Zlpy6Ko2H/blobs/eaDMPGz4QTvPDac0HlPR/image.png" alt=""><figcaption></figcaption></figure>

* The selected transform gets applied to those columns.

<figure><img src="https://content.gitbook.com/content/TEE47Mdie26Zlpy6Ko2H/blobs/PDZe10aLK1vT2biC4UiH/image.png" alt=""><figcaption><p><em><strong>Displaying Transformed Data</strong></em> </p></figcaption></figure>