Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:user_guide:worksheet_lists [2020/06/23 11:04] tiger [Know your process for one worksheet; then switch to multiple] |
en:user_guide:worksheet_lists [2021/01/10 14:44] (current) tiger [Know your process for one worksheet; then switch to multiple] |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| ===== Consolidating data from multiple source worksheets to a single target worksheet ===== | ===== Consolidating data from multiple source worksheets to a single target worksheet ===== | ||
| - | The source worksheets that should be consolidated do already exist having their filenames at hand. Therefore best practice is to use the **WBook List Start** and **WBook List Next** process steps (under categories Worksheet and If / Lists on the [[en: | + | The source worksheets that should be consolidated do already exist having their filenames at hand. Therefore best practice is to use the **[[en: |
| Under the workbook list parameter the workbooks of the source worksheets can be specified using: | Under the workbook list parameter the workbooks of the source worksheets can be specified using: | ||
| * wildcard characters ? and * in filenames (e.g. c: | * wildcard characters ? and * in filenames (e.g. c: | ||
| * multiple folders or files separated by ; (e.g. c: | * multiple folders or files separated by ; (e.g. c: | ||
| - | |||
| - | |||
| ==== Know your process for one worksheet; then switch to multiple ==== | ==== Know your process for one worksheet; then switch to multiple ==== | ||
| - | The first step is to specify the process for one source worksheet just like it is done for a single worksheet case. Use **WSheet Use** to specify the target consolidation worksheet and another **WSheet Use** for the only source worksheet. Once the process is up and running follow these steps: | + | The first step is to specify the process for one source worksheet just like it is done for a single worksheet case. Use **[[en: |
| - | - replace **WSheet Use** for the only source worksheet by **WBook List Start** for all the worksheets at the beginning (NB: keep **WSheet Use** for the target!); | + | - replace **WSheet Use** for the only source worksheet by **WBook List Start** for all the worksheets at the beginning |
| - specify all the worksheets in the Workbook list parameter | - specify all the worksheets in the Workbook list parameter | ||
| - add **WBook List Next** to the end of the operations; | - add **WBook List Next** to the end of the operations; | ||
| Line 25: | Line 23: | ||
| * appending rows; | * appending rows; | ||
| * inserting rows; and | * inserting rows; and | ||
| - | * accumulating values instead of overwriting the same cell again and again. See detailed at the below sections. | + | * accumulating values instead of overwriting the same cell again and again. See these steps detailed at the sections |
| Done! | Done! | ||
| Line 83: | Line 81: | ||
| Cell Set Cell: wsTarget!C5 | Cell Set Cell: wsTarget!C5 | ||
| Value: 1 | Value: 1 | ||
| - | Cell Set Cell: wsTarget!C4 | + | Cell Set Cell: wsTarget!C4 |
| Value: [=wsSource!D5] | Value: [=wsSource!D5] | ||
| Line 110: | Line 108: | ||
| - If the target worksheets are to be created using the information from the source worksheet itself then the **WSheet Split** process step can be used | - If the target worksheets are to be created using the information from the source worksheet itself then the **WSheet Split** process step can be used | ||
| + | Let's see these ways in details. | ||
| ==== Creating target worksheets in a WBook List ==== | ==== Creating target worksheets in a WBook List ==== | ||