Manage input and workflow in a efficient way

Question

Hi Guys,

I have one concern like below:

supposed I have several input for reading large data from excel file and it costs 10 seconds, and these input data are using for lots of scenario(approximate 30 scenes), and at most I can handle 3-4 scenes at one canvas cause lots of lines and tools I need to drag and pull. i have to separate these into 10 workflows which will result in that I have to read these data source for 10 times. this costs extra time which i don't expect, is there any better solution that I can handle this?

187 · Answer

@ArtApa  Hi ArtApa  Thank you for the reply,

Is there any way i can pass a Dataset to Macros?  the painpoint we met now is we dont want to read data from source files multiple time, but with this, we can only make all actions in one workflow and this will make the canvas quite huge with lots of lines and tools and containers. but if I split those into several workflows or macros, this would cause I have to define multiple inputs for reading data. I dont know if there is any way that we can pass several data sets to macros?

ArtApa · Answer

Hi @187 - Without know much about your workflows one thing I can recommend is as the first step to convert your excel files to yxdb to improve performance.