You can add or edit steps in your recipe through the Recipe panel, which is available on the right side of the Transformer page.
To edit the recipe:
On the right side of the screen is the empty recipe panel. You have no steps in your recipe. You can add recipe steps in any of the following ways:
You can highlight a cell value, a column, a row, or even part of a cell value, and provides a list of suggestions in the panel to the right. For more information, see Transform Basics.
Search for a function or transformation:
If the recipe panel is not displayed on the right side of the screen, click the Recipe icon in the menubar at the top of the screen.
In the panel on the right side of the Transformer page, click Add New Step. The Search transformation panel is displayed.
In the Search panel, you can search for the transformations. Enter the search term, the corresponding transformation or function is underlined in the search panel. The following example shows a search for add.
Tip: To see a list of all available functions, enter
After you select the required transformation or function, the Transform Builder is displayed with the pre-specified function.
Edit the recipe directly:
After you have added a few steps and are comfortable with the process, you can begin to explore editing the recipe directly.