Introduction
Have you ever found yourself with incomplete or incorrect data in a dataset? It can be frustrating, especially when you need to analyze or report on that data. Fortunately, there are tools available to help you quickly and easily fill in missing values. In this guide, we'll show you how to use multi-row FILL in the Transform tool.
Identifying Missing Values
Before we can fill in missing values, we need to identify where they are in our dataset. In our example, we want to fill in the missing value for Customer Name. We can see from the screenshot that this value is missing for the first row in the dataset.
Using multi-row FILL to Populate Missing Values
To fill in the missing value for Customer Name, we'll use multi-row FILL in the Transform tool. Here's how:
Click the
+ Fieldbutton in Transform to create a new field, or click theUpdate Original Fieldbutton (in the icon list next to the field name) to update an existing field.If you're creating a new field, give it a name.
Then select the 🟣 Multi-Row option from the radio button list directly below.
Choose
FILLfor the calculation type.Finally, select Customer Name as your argument.
Then click Confirm and 🙏 high five. You're done!
Conclusion
Filling in missing values in a dataset can be a time-consuming and frustrating process, but multi-row FILL makes it much easier. By following the steps outlined in this guide, you can quickly and accurately fill in missing values and get back to analyzing your data.