Thanks for the reply @pattyricarte
Yes. I have multiple excel files stored in a single folder, and I have to perform web-based operations on data within the excel sheet.
I can read the excel sheet one by one.
I can also read the data required.
The problem is that I want to put into a state machine structure, such that each of the excel files will be read in one go and stored in individual data tables. Since I don’t know the number of files in the folder, I have done the following:
Now I have a list of the names, but not the data in the files themselves.
So I want to store the data table generated from the read range into an array/list as advised by @marci080. I was trying this:
My error comes up in the last Assign activity.
My variables are as follows:
With the state machine situation, I have divided the input into states such that I first get a list of files. Then I want to read all the excel files into individual data tables and store all the data tables in an array/list. Then in the next, each data table is read and operation is performed.
Previously, using only sequences I was able to get the data onto the website from each file as follows:
with the variables:
With the state machine situation, I have divided the input into states such that I first get a list of files. Then I read and store all the data tables in an array/list. Then in the next, each data table is read and operation is performed.