Hi ​@Mahesh Kumar.T ,

Could you please try the Get Table property within the Capture action which will directly help you to save the result into a DataTable variable.

Later on, you can loop through that variable and do the necessary actions as per your requirement.

Hope this will help.

​@Padmakumar, Thanks for the reply
Yes, I have only used the get table. This does not issue
I need to write the extracted data to an Excel file 
We need to add the school's name and the rest of the tabular data to the Excel file
I have created the data table variable to add all the required data, but I am unable to do  add all data into one table

​@Padmakumar, Thanks for the reply
Yes, I have only used the get table. This does not issue
I need to write the data table to an Excel file 
We need to add the school's name and the rest of the tabular data to the Excel file
I have created the data table variable to add all the required data, but I am unable to do  add all data into one table

 

Could you please help me with the error you are getting then?

Also, since the GetTable property will create a Data Table output (in your case, it is CapturedTableData), I am not getting the purpose of assigning the result to a record variable and again inserting it into a different Data Table. Instead of that, why don't we directly loop through the DataTable and assign each record into the Excel rows as per your requirement!

​@Mahesh Kumar.T  instead of assign the value to induvial variable you can follow below method.
1- capture complete data into data table
2- Apply loop over data table 
3- write data into excel using excel as db method where you can write a data base on school code

Hope this help your question  

This would be a correct approach, also ​@Mahesh Kumar.T , you can try looping the Data table using for each row is data table and basis on each row you can write the data using record variable and then One cell to the right.

Thanks ​@Rehan.S1 
Just wondering already, we have extracted the school data and that data in the data table so only thing we need add the school name to existing data table then we can write the data table into the excel so make it simple?
Requirement: we need extract the school's name and school data based on the code school and finally we need write the data into the excel

Please correct me if I am m wrong.

​@Mahesh Kumar.T Yes it will be easy approach just extract a data and write the school name in existing table and perform whatever operation you want like write into excel base on code or other operation you want. Also same data table you can use for other task also if needed.
Hope this clear you doubt and give a better answer.