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:13] 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 is filtered by the category name in column C of the current row in the row list (#) | + | * For each row, the data worksheet |
| * 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 | ||
| Line 42: | Line 45: | ||
| < | < | ||
| - | WSheet Use wsOriginalData | + | WSheet Use: Djeeni name: wsOriginalData |
| - | Row List Start: wsAdditionsUpdates | + | Row List Start: Djeeni name: wsAdditionsUpdates |
| - | WSheet Filter Add: filter wsOriginalData | + | WSheet Filter Add: filter wsOriginalData |
| + | Range Set: on wsOriginalData target column using value wsAdditionsUpdates cell B# | ||
| + | WSheet Filter Clear wsData | ||
| + | Row List End | ||
| + | </ | ||
| + | |||
| + | This is what happens: | ||
| + | * The original data worksheet is opened | ||
| + | * The row list takes the rows of the categories worksheet one by one | ||
| + | * For each row, the data worksheet (where column D contains some ID value) is filtered by the same ID value in column C of the current row (#) on wsAdditionsUpdates | ||
| + | * The value of cell B# of the wsAdditionsUpdates worksheet is added/ | ||
| + | * The filter is cleared to let the next filter be applied | ||
| + | * The next row in the row list is taken and the loop restarts | ||
| | | ||
| Read further about row lists [[en: | Read further about row lists [[en: | ||