User Tools

Site Tools


transformations:fillright

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

transformations:fillright [2018/01/11 21:11] – created dmitrytransformations:fillright [2021/06/17 21:38] (current) craigt
Line 1: Line 1:
-===== Fill right =====+{{ transformations:FillRightAction.png}} 
 +====== FILL RIGHT ====== 
 +Category: Transform / Advanced\\
  
-CategoryTransformation / Advanced+\\  
 +=====Description===== 
 +This action is similar to the [[transformations:fillgaps|Fill down]] action, only it fills empty cells to the right.\\
  
-This transformation is similar to the [[transformations:fillgaps|Fill down]] transformation, 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.
  
-**Use cases**+\\  
 +=====Action settings===== 
 +^Setting ^Description ^ 
 +|Row number<sup>*</sup>|Enter the row to fill blank cells to the right in.| 
 +|Ignore columns|Select the column(s) where values with //not// be filled across in.| 
 +<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
  
-The most frequent use case for this transformation is dealing with merged cells in imported Excel spreadsheets.+\\  
 +=====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:fillgaps|Fill down]]
transformations/fillright.1515723116.txt.gz · Last modified: 2018/01/11 21:11 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki