I have some excel spreadsheet will be used multiple times in several workflow in my project.
Because I don’t want the line crossing the nodes, every time I need to manipulate data in that excel spreadsheet, I will insert an excel reader, which makes my workflow running slowly, is there any way to improve this?
Hi @cuimaple,
I have a hard time comprehending what you want to say. Would you be so kind to share a screenshot of your workflow and maybe rephrase your problem. If English isn’t your mother tongue, may I suggest you use Google Translate to translate your native lagnuage?
Best
Mike
For example, I will use data from the same excel spreadsheet repeatedly, the excel spreadsheet is loaded into workflow many times, that makes my workflow getting slowly. And why I loaded the same excel spreadsheet into the workflow repeatedly, is because I want to make the line connecting the nodes not cross-over each other. Is there any approach to optimize this?
Reusing data is the whole point I think. You can try curved connections to improve the layout.
Only other idea would be to load once, store in a temporary table and read that several times.
And currently you have the flow variables passing your black line …
Based on the Joiner node I believe he is reading the same Excel but different sheets. You could theoretically use the Read Excel Sheet Names and loop over that table.
Then you’d use a Generic Loop End, adding multiple collection ports and conditionally switch, based on the iteration, the output port using a switch to so each table is send to a distinct port.
Though, that deprives you from the ability to parallel read all data, increasing abstractness due to the loop and not necessarily eases the complexity.
can you share more about: Only other idea would be to load once, store in a temporary table and read that several times.
if I load tables in this way, will it be refresh every time I execute the workflow?
Why are the Excel File Readers getting reset? Is there any need for that?
actually I am reading the same sheet. I am doing this because I don’t want the line cross-over nodes.
If that is the case, do not die in virtuosity. The limitations imposed by reading the same data over and over isn’t worth it.