User Tools

Site Tools


transformations:fillright

FILL RIGHT

Category: Transform / Advanced


Description

This action is similar to the Fill down action, only it fills empty cells to the right.


Use cases

The most frequent use case for this action is dealing with merged cells within imported Excel spreadsheets.


Action settings

Setting Description
Row number*Enter the row to fill blank cells to the right in.
Ignore columnsSelect the column(s) where values with not be filled across in.

* Setting can be specified using a parameter.


Remarks

Blank cells are populated starting from the left and moving rightward across the row. The value from the cell to the left is used to fill in each blank cell.


Examples

Example: Fill in the blank heading cells from an imported Excel pivottable.

Source table:

Column Column(2) Column(3) Column(4) Column(5) Column(6) Column(7)
Canada France Spain
Quebec Montreal Ontario Paris Lyon Barcelona Madrid


Action parameters:

Row number is "1"
Ignore columns - none are selected


Result table:

Column Column(2) Column(3) Column(4) Column(5) Column(6) Column(7)
Canada Canada Canada France France Spain Spain
Quebec Montreal Ontario Paris Lyon Barcelona Madrid


See also

transformations/fillright.txt · Last modified: 2021/06/17 21:38 by craigt