Via a machine learning algorithm, this function allows you to define a pattern, and automatically apply a transformation on a whole column, based on a few examples that you define beforehand.
At the moment, the Magic Fill function only supports the following transformation types:
- addition of constants (numbers, letters, special characters)
- case sensitivity
- semantic transformation for countries, states, emails, URLs and months
For the function to work, you need to enter at least two examples of the transformation you want to apply. You can then add up to three other examples. The more examples you input, the more accurately the pattern will be identified by the function.
Data types such as
phone numbers both have dedicated function that can
be used to easily change their format. However
social security numbers or
state codes, for example, do not. The following scenarios will
illustrate how to use the Magic Fill function to format your data in those cases.