Site Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
en:user_guide:tips [2020/06/17 12:17]
tiger [Process structure]
en:user_guide:tips [2020/06/17 12:23] (current)
tiger [Process structure]
Line 17: Line 17:
   - At the end of every block release the source and target worksheets that are not needed further in the process using **WSheet Release**.   - At the end of every block release the source and target worksheets that are not needed further in the process using **WSheet Release**.
   - Within a block focus on the target structure with the question: how this cell / range gets its value?. Identify ranges that can get a value in one step instead of dealing with every cell separately.   - Within a block focus on the target structure with the question: how this cell / range gets its value?. Identify ranges that can get a value in one step instead of dealing with every cell separately.
 +  - Pay attention to templates: most of them are row oriented (similar data below each other) but there are many exception of colum oriented templates (similar data next to each other). You can easily transpose row orinted ranges to column oriented ranges in DJeeni instead of filling the target range celss one by one but you have to recognise this option by understanding the template structures of the worksheets.
  
-If calculations look too complex for a direct source-target process then consider building a two-phase process: in the first phase create intermediary/​storage targets that contain the results of some calculations or enrich the input. Then the second phase uses these intermediary targets as source worksheets (next to the original ones) to create the final targets.+If calculations look too complex for a direct source-target process then consider building a two-phase process: in the first phase create intermediary/​storage targets that contain the results of some calculationsor enrich the input. Then the second phase uses these intermediary targets as source worksheets (next to the original ones) to create the final targets.
 ===== Use Templates ===== ===== Use Templates =====