Learn how to fill down rows in a group in a workbook.
The attached the JSON definition of a workbook implements the functionality of GROUP_FILL_DOWN step-by-step.
You can upload it as described in REST API - Create Workbook.
For quick reference, the steps are noted here:
- Upload the data set in
- On the Data worksheet, use
GROUPBY(#Name),GROUPBY(#Account),and (depending on your source)
GROUPROWNUMBER()to implement a group sort key.
- Duplicate the worksheet and name it PostProcess.
GROUPBY(#Data!Name), and GROUPMAX(#Data!Account)
- Create a new sheet called JoinedSheet with:
- An inner join on