I am trying to merge output of multiple excel files into one list that can then be used by an AI. Aggregate is returning 4 different outputs. as each excel runs at a different time. Merge is returning everything as one huge excel which i do not want. I want a list that has 4 items each corresponding to one excel.
Even my custom code is returning 4 different items.
How do I solve this
Try using a merge combine with 4 inputs: