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: Enrich or update data on a worksheet] |
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 ===== | ||
| Line 30: | Line 33: | ||
| This is what happens: | This is what happens: | ||
| * The row list takes the rows of the categories worksheet one by one | * The row list takes the rows of the categories worksheet one by one | ||
| - | * For each row, the data worksheet (where column D contains category names) is filtered by the category name in column C of the current row in the row list (#) | + | * For each row, the data worksheet (where column D contains category names) is filtered by the category name in column C of the current row (#) on wsCategoryData |
| * The new worksheet is created in a new workbook (alternatively a new worksheet can be added to an existing workbook) | * The new worksheet is created in a new workbook (alternatively a new worksheet can be added to an existing workbook) | ||
| * The filtered data range is copied to the newly created worksheet | * The filtered data range is copied to the newly created worksheet | ||