I am extracting a data from web application and using in for each loop when bot is trying to insert value 2nd time then its overwriting the value means previous value is gone as show case below also empty field is not checked even though issue is coming
Giving in Type into activity like this : Col_serial + " "
Actually i m comaring the value from spreadsheet from item # in this application if item match then it should insert the value on same field keeping previous value
As per my understanding, you are getting some data from a web application( consider 10 rows of data), you want to append all the data from one column and need to add it to the Serial Number. Is this correct?
If this is the requirement, you have to use the For each row in Data table activity and add the values to a variable. For example StrOut=CurrentRow(0).ToString+Environment.NewLine.
StrtOut is a String Variable and CurrentRow(0) will fetch the value from teh first column(change as per the requirement). Then once loop ends you can use StrOut to add in the serial Number column