Maya229
September 14, 2022, 1:00pm
1
Hi all,
could you please check my WF, maybe/hopefully there is just sth small missing, I’m not that familiar with loops so far:
WF_Read_multiple_files.knwf (29.1 KB)
DemoData_2022.xls (49 KB)
I managed to read all the spreadsheet names, and have an correct iteration and the correct spreadsheet name, but always with the data from the first spreadsheet, I would like to have the data from each Spreadsheet there, and not only from the first
Any ideas what I did wrong?
Thank you very much!
@Maya229 it might be this problem. You could try and force the use of sheet name via Flow Variable:
@Geo what you could do is force the use of sheet_selection = “NAME” thru a Flow Variable in case of doubt. Maybe not the most elegant way but shout provide an additional layer of security.
[image]
And indeed under certain circumstances it seems to revert to the default value. Not able to reproduce it yet in a constant way. But might be worth looking into, @laaaarsi .
[image]
3 Likes
system
December 13, 2022, 1:41pm
3
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
