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

ella_

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:

<参数键= " enable_parallel_execution" value="true"/>









<参数键= " enable_parallel_execution" value="true"/>

<运营商激活= " true " class = " read_excel”薪酬atibility="9.5.001" expanded="true" height="68" name="Read Excel" width="90" x="45" y="85">

varunm1

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.