How to save the extracted dynamic match values into excel sheet

Help Studio
, ,
22

image
image736×288 3.9 KB

23

Its showing output message box for only one output

24

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

25

@_Bhagyashree

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

Cheers

26

Hi @Anil_G

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.

27

Hi @Anil_G

It worked before adding build data table,add data row and write range it was showing two outputs.Now its showing only one output

28

@_Bhagyashree

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

cheers

29

Hi @Anil_G

I am not getting exactly.Can you please send me the xaml file to understand.

30

@_Bhagyashree

Can you print and show what is the string in value variable please

And exactly what your requirement is

Cheers

31

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.

32

@_Bhagyashree

Okay so what you have to do is

  1. Read the data present in excel
  2. Add datatcolumn if the required column is not present already
  3. 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

Cheers

33

Hi @Anil_G

As u said to read data from excel sheet.There is no data yet to read from excel sheet.

34

@_Bhagyashree

Then readit feom where it is…ideally you should be knowing where the data is…apart from that steps remain same

Cheers

35

The row 1 should not update …First value should come in row 1 and second value should come in row 2.

36

@_Bhagyashree

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

Cheers