This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a dataset like this, i would like to summarize by grouping transaction ID and selecting the last non-null value, if any (if no non-null value, i would like to have null shows in the output). The intended output is as shown below in the second table. Please kindly advise what can i do? Thanks!!
For what you need is it better to use a filter to get rid of the nulls, then summarise (group by ID and last payment plan), then join back to your original data set and union to find the unmatched (null) transaction IDs?
EDIT: I've attached a workflow, it's a bit scrappy, but seems to work as you want?