Based on the example that you will input, the Magic Fill function also has the ability to recognize and format data that corresponds to certain semantic types: countries, emails, URLs, dates, as well as US postal codes and states.
Let's take the example of a dataset containing some customer information, like their names, email addresses, or the state they live in. This scenario will illustrate how you can use the Magic Fill function to convert the two-letter state codes to their full state name equivalent, to have them in a format that is easier to read.
- Click the header of the state column in order to select its content.
- In the functions panel, type Magic fill and click the result to display the options of the associated function.
- In the Input 1 field, enter one of the values from the state column that you would like to transform, NY for example.
In the Output 1 field,
enter the full name of the corresponding state: New-York.
For the function to work, you need to enter at least two complete examples of the transformation you want to apply. You can then add up to three other examples. Examples can be taken from your dataset, or you can use other valid US state code values from outside your dataset. The more examples you input, the more accurately the transformation will be identified by the function.
Enter more before and after examples in the remaining
- AZ as Input 2 and Arizona as Output 2
- TX as Input 3 and Texas as Output 3
- IN as Input 4 and Indiana as Output 4
- MI as Input 5 and Michigan as Output 5
Based on these examples, the function will understand that the all the inputs you entered are two-letter state codes, and the outputs are full state names, and will apply the corresponding transformation to the rest of the column.
- Click Submit.
US Statesemantic type, ensuring that they are in the good format. You can now delete the state column.