Greetings for the day,
I am new to Uipath and I am trying to create an automation where I need to add data to a particular column in the data table and at the same time add new data rows.
For example there are 5 reports in the datatable as shown in the screenshot
and each report has multiple measures which are being extracted using the data scraping activity in uipath post which the extracted measures are written into an excel file
the expected output is something like
Measures which are mapped to a single report get appended to other reports rather than the new rows being added. I have tried the add data row activity but still the desired result is not achieved.
Is there any other way to do it
no can you explain it a little on how to do it.
For now i the excel sheet that the bot reads before extracting the measures has the report name and currently I am trying to make it work only for one report as if it works for one report it will work for other reports as well
we would recommend to add datarows in a format, the relationship e.g. Measure 2- Report 1 is not lost. As we can add such update rows on the end, after a sorting the datatable on Report, we will get it back close as mentioned above