Its showing output message box for only one output
I am extracting 2 output values and from that i am extracting perticular number by using match regex.
Bot is showing only output in output message box.
Before it showed for both 2 outputs
If your in argument is matches
Then type argument should be of type system.text.regularexpressions.regex.match
Then inside currentitem.value will give the value of it
Flowchart2.xaml (126.6 KB)
In this i am able to get the match output value for first value but its not getting the output for second value.
It worked before adding build data table,add data row and write range it was showing two outputs.Now its showing only one output
After extracting the data if you do a build a datatable then the data will get erased that is the reason you are not seeing it
If you want to add values extracted to a datatable then either add it to a new table or add according to the structure of the table retrieved in Extract activity
I am not getting exactly.Can you please send me the xaml file to understand.
Can you print and show what is the string in value variable please
And exactly what your requirement is
The input string value is
Created Request UIPK900247 with Task UIPK900247 for ABC
Created Request UIPK900248 with Task UIPK900287 for ABC
From this i have extracted UIPK900247 and UIPK900248 one by one by using match regex value in for each activity.
I have to get this extracted value one by one in excel sheet in one of the column.
Okay so what you have to do is
- Read the data present in excel
- Add datatcolumn if the required column is not present already
- Then use the same for loop and if you want to add new row then use add datat row …else if you want to update specific row present already then use assign and you have to giv eht required row value or use a for each row in datatable and append it
Dt(0)("colname") = currentitem.value
This will update row zero column colname
As u said to read data from excel sheet.There is no data yet to read from excel sheet.
Then readit feom where it is…ideally you should be knowing where the data is…apart from that steps remain same
The row 1 should not update …First value should come in row 1 and second value should come in row 2.
Then add a blank row at first
Or on excel if you want only from second then give the first cell accordingly to paste from there
Or use if condition to not update first row