Recent content by APatel

  1. A

    Transpose Collection in Blue Prism

    Hello, I need help with code stage to transpose the collection as seen in the screenshots. I need to take columns from E to N and it's values and transpose them as columns for each row. The values for columns A to D should copy down to the last row for each date (as seen in row 8 to 38) Is this...
  2. A

    Adding Comment in Excel using Blue Prism

    Thank you for your response. I will try that option. Do you know if Macro would work? Thanks.
  3. A

    Adding Comment in Excel using Blue Prism

    Hello, Is there a way to add a comment in excel cell using Blue Prism? Please see the screenshot. Thank you.
  4. A

    Adding Rows to Collection

    Please See the attached file
  5. A

    Adding Rows to Collection

    I do not have the 10 rows in collection yet. I am trying to add those 10 rows into collection using multi calc stage. but only the last row gets added at the end to the collection. Even if I add 10 rows using the count before, the first 9 rows are blank and the last one gets filled with 10th row...
  6. A

    Adding Rows to Collection

    So I need to first figure out how to write multi-calc stage with 10 rows into a new collection. At the end I am able to add 10 rows to new collection but first 1-9 rows are empty and only last row has 10th row filled in. so the question is how to get new collection with all 10 rows filled with...
  7. A

    Adding Rows to Collection

    Hello, Thank you for your response. I tried "Append Rows to collection", but I am still not getting the result I want.
  8. A

    Adding Rows to Collection

    ------------------------------------------------------------- Hello, Thank you for your response. I tried it this way and it adds 12 rows to collection but only the 12th row gets filled with values. The rows 1 to 11 in collection are empty.
  9. A

    Adding Rows to Collection

    Hello, I have number of rows that I want to add to collection. I am using multi-calc stage which has 10 entries that I want to add to collection. I am also using "Add Row" from collection VBO but that only adds 1 row to collection so when the process runs, it replaces each entry and at the end...
  10. A

    Extract Regex Values

    Hello, This is great.... It worked!!! Thank you for your support.
  11. A

    Extract Regex Values

    Hello, Can someone please help me with regex? I am trying to extract the following two items in the string below using Utility-Strings- Extract regex values in Blue Prism. String= "Test=Check: 12345 for 10 Orders with 100:SN 1 Code: ABCDE" 1) Extract the values between the words for and...
Top