Logic for pushing data to Queue

Help Studio
1

PushStockDataToQueue.xaml (7.2 KB)

Hi im trying to create a queue in orchestrator tp push data i have in folder containing multiple files.

I have folder a folder with 7 excel files, how can i write a logic that incorporates all the files?

Many thanks

2

That depends on what you’re considering as a queue item. Is it the path to the Excel file? A value in a cell from an Excel file?

3

its a path to an excel file but i have 7 files

4

Use a For Each loop, and iterate over System.IO.Directory.GetFiles(Path), where Path is the directory where the Excel files are kept. Then you can load the path to the file in the loop using a string.

1 Like