!!! Understanding functions and processes
Certainly! Here's the passage rewritten in the third person in English:
Understanding Functions and Processes, version 4.6.6.6.
When transformations were performed to obtain data related to the product table, they needed to utilize the SplitString function to separate the brand, size, and flavor from the product descriptor. If one were to edit the transformation that creates a new column and click on "Objects," followed by "Save," a list of pre-provided functions for creating a new column would appear. How does one know what these functions are? What are their types? And what parameters need to be entered for the function to work? Let's delve into it.
Click on "Close."
Close it again. And by going to "Data Container," one would find the option "Functions and Processes Standard." By clicking on this option, a group of functions separated into three types would appear on the left side: Standard Functions and Processes, Standard Processes, and Transformations.
The functions seen when selecting a functionality for creating a new column are contained within "Functions and Processes." These functions are separated by various types: string functions, numerical functions, date functions, conversion functions, and miscellaneous functions. As new versions and upgrades of the product are made available, the number of functions increases.
If one were to open "Functions and Strings," they would find all the functions available, including the one used, "Split String."
To check what this function does, one would find a name, a descriptor, and the necessary parameters. In this case, the string to be separated, the separator, and the position. These are exactly the three parameters included when constructing the transformation.
To test the function's operation, one could click on the "Preview Functions" button and specify the parameters separated by a tag that opens with "parameter" and closes with "/parameter." For example, one could type "parameter" and any string separated by, for instance, a semicolon, and then close the "parameter" tag.
The second parameter of the function is the separator. In this case, the semicolon. And the third parameter is the position. Suppose one wants to retrieve element 1. Looking at the parameters' declaration, it is known that the result should be "BBBB," which is position 1 within that string if a split is made by a semicolon. By clicking "Execute Function in Process," the result would be "BBBB." Thus, the function can be tested.
Below, the parameters, the result, and the time to execute this function are displayed. Of course, at this point in the course, it is not necessary to verify what each of these functions does, mainly because they are extremely dynamic. With each new version of the product, more functions become available. As we progress with this course, we will use more functions existing in this list and be able to comment more thoroughly on each one. Thank you and until the next video!