Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:concepts:rowlist [2020/02/24 11:24] tiger [Example: Split data] |
en:concepts:rowlist [2021/04/26 23:00] (current) tiger |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Processing the rows on a worksheet ====== | + | {{indexmenu_n> |
| + | ====== Processing the rows/columns one by one on a worksheet ====== | ||
| - | A common task is to process data in a data source according to categories that can be found on another worksheet. A good example is having a list of departments managed in a worksheet and independently some reports that should be generated // | + | A common task is to process data in a data source according to categories that can be found on another worksheet. A good example is having a list of departments managed in a worksheet and independently some reports that should be generated // |
| - | A row list is a loop between the **Row List Start** and **Row List Next** process steps. At **Row List Start** you specify the worksheet and the rows on the worksheet that should be processed. Djeeni will take the rows one by one and then performs the further | + | A //row list// is a loop between the **[[en: |
| < | < | ||
| Line 12: | Line 13: | ||
| You can reach any cells in the current row by referring to the appropriate column letter and #. Example: if the cell in column D of the current row in the row list must be accessed then you can type D#. | You can reach any cells in the current row by referring to the appropriate column letter and #. Example: if the cell in column D of the current row in the row list must be accessed then you can type D#. | ||
| + | |||
| + | A //column list// works the same way looping through columns. It uses also the # sign to refer to the current column: #3. | ||
| ===== Example: Split data ===== | ===== Example: Split data ===== | ||