Fill last good value after merge using Trim-functionality (Q926)

The information in this article applies to: 

The Merge feature assumes that missing value is a valid entry when it appears on a row with numbers in other variables. This means that filling with Last good value when there is a missing value that is perceived as a good value results in more missing data than you might have expected.


After merging your data, use the Trim-Winz feature in the Data Explorer pane to first Find missing values and then Replace with last good value.

Date modified: Sep 09, 2019
Article type: