How to loop over Excel files in a folder and append them to one Example Set containing all files

ella_ella_ MemberPosts:3Contributor I
edited February 2020 inHelp
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"/>






















































Jasmine_

Answers

  • varunm1varunm1 Moderator, MemberPosts:1,207Unicorn
    edited February 2020
    Hello@ella_

    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.
    Regards,
    Varun
    https://www.varunmandalapu.com/

    Be Safe. Follow precautions and Maintain Social Distancing

    Jasmine_
Sign InorRegisterto comment.