Hi All ,I have a use case where I need to copy a specific range from an Excel table and store it in a calculation stage, including in my email body. Could someone guide me on how to achieve this in Blue Prism?
Hi everyone,I have a data item in Blue Prism that contains multiple codes stored as follows:1236718V981A876287672087740767I need to format this data item so that it appears like this: '12367','18V98','1A876','28767','20877','40767'.How can I achieve ...
HiI need help with extracting a CSV file from a database using SQL queries in Blue Prism. In the development environment, everything worked fine. However, now that my bot is in production, the CSV file size exceeds 2 GB, causing an "Out of Memory" is...
I need to write data from a data item into an Excel sheet, with each value written into separate cells, one below the other.My data item contains six values, and I need to ensure each value is placed in its own cell in a column.Values in DATA Item ar...
I'm seeking advice on structuring a data storage system for the last 6 months' worth of codes. Each code follows a consistent pattern: GOV followed by a number representing the month (e.g., GOV3, GOV2, GOV1, GOV12, GOV11, GOV10). What would be the mo...
Thanks @Mohamad_747 for your answer but below is my requirementLets consider My input excel looks like this :And The message body I am looking for looks like this : Hi Team ,Please find the below table FYR NAMEPRENAMECONTRACTAQabcdBWefghCEhijkDRlmno...
if today's date is, for instance, 31st October, I want the start date to be the nearest previous 15th, which means it should be 15th October. How can I handle this situation ?------------------------------Sandy P------------------------------
