How to loop over Excel files in a folder and append them to one Example Set containing all files
Hi,
I was trying to loop over 3 Excel files in a folder and append them to one Example Set containing all 3 Example Sets.
Plotting over a continuously id shows that unfortunately my final Example Set contains 3 times the first Example Set.
I was looping over the parameter index of the select operator which selects a file of the loop files subprocess which contains the read Excel operator.
Can someone please help me to solve the problem?
Best
Ella
Attached Process:
<参数键= value =“macro_for_file_type file_type"/>
<参数键= value =“sheet_selection麻木er"/>
I was trying to loop over 3 Excel files in a folder and append them to one Example Set containing all 3 Example Sets.
Plotting over a continuously id shows that unfortunately my final Example Set contains 3 times the first Example Set.
I was looping over the parameter index of the select operator which selects a file of the loop files subprocess which contains the read Excel operator.
Can someone please help me to solve the problem?
Best
Ella
Attached Process:
<参数键= value =“macro_for_file_type file_type"/>
<参数键= value =“sheet_selection麻木er"/>
Tagged:
1
Answers
Why don't you directly loop files and append, instead of using the loop parameters?
One issue I found is in the "Select" operator. You hardcoded "1" in that, you change it to macro %{execution_count} and check if you are getting all three.
Varun
https://www.varunmandalapu.com/
Be Safe. Follow precautions and Maintain Social Distancing