Hi, I have a Build DataTable with the following columns, Applicant Number & Payment Number. And through a loop, I will use Get Text to get the Applicant Number and Payment Number from a web portal. Afterwards, I use a add DataRow activity to add the extracted data to the DataTable. I then want the bot to write the data into 2 existing columns in my excel file but when I used write range, it writes the Applicant Number and Payment Number into 1 column instead of 2. Appreciate all the help I can get! Thank you
Example of what I get at the end of my process:
Here is my add data row activities:
Here is my write range activity:
