Worksheet Execution stopping
Hi All need your help on the following:
1. I have built a workbook with sheets catering to different test scenario. example Sheet1 may be a aggregation of a dimension, Sheet2 just has the aggregation of numeric fields. Sheet3&4 might contain aggregation with different source.
2. When I change something I would like to ensure that on the sheet where in I have made changes should get executed and others should be stopped from execution. Can we do this? to speed up results rendering time
-
Hello Ganesh.
A Workbook is a chain of Sheets that are processed sequentially. Therefore, it is not possible to exclude a particular Sheet from processing. If you would like to build several variants of transformation of the same data, it is better to create a separate Workbook for each of them - this way, you could avoid unnecessary data processing.
Another recommendation is to do not save intermediate Sheet results. This helps to decrease data volume written to the storage and thus improve the execution time.
Please sign in to leave a comment.
Comments
1 comment