I am trying to build my project in a different way to optimize performance but I’m running into an issue.
What I have now is a workflow that scrapes a table from a website, outputs it as a new data table, and then writes that table to an excel file. In the next workflow (which is invoked), I open up that excel file and read range to a new data table. I then run my operations on that data table and write the updated info back to the excel sheet
I’m trying to eliminate the excel sheet until I am done with the operations so I can write the whole table back at once, not piece by piece to the file on each iteration.
The issue I am running into is that in workflow1 (named for convenience) the data table that is generated (and that I would normally write to an excel file) is not in the global scope and won’t let me change it. I tried to pass it into workflow2 as an import argument but it isn’t showing up in the available variables.
Summary, the data table created in workflow1 is not showing up as an argument to import into workflow2
If I was unclear please let me know so I can try to explain it further.
Thank you for any help given