Thank you so much @sahil_raina_91 .
The file is a csv and not an Excel.
I'm getting this error when using this action:
'Get Worksheet as Collection' Process: 'Test' Subsheet: 'Get Collection From Csv' ERROR: Internal : Could not execute code stage because exception thrown by code stage: Illegal...
Thank you so much @sahil_raina_91.
I've tried the SQL server data - Set Connection and it works.
Now I ask you another question:
I need to Read an Excel File , Read the Collection of rows associated to it and insert the rows (without duplicates) in a Datatable inside the Database.
How can I do...
Hi, (@sahil_raina_91, @Pete_L )
I want to ask you kindly which are the steps necessary to connect BluePrism to a Table in SqlServerExpress and execute a query on it.
What are the steps involved?
CAn you please provide me an example of workflow that does this?
Thank you so much,
How to get the last date of a month with out using any code stage?
I would like to get that only by passing as parameters the year and month, not the day.
Any ideas and suggestions appreciated.
I am trying to pass the value in the cell using SET CELL Value function however it is throwing error ""HRESULT: 0x800A03EC""
The value is ""=+VLOOKUP(B3,'C:\*******\[ConsolidatedReport.xlsx]Sheet1'!$A$1:$N$1600,1,FALSE)".
I have valdated it before running. However i have an...
I would like to clarify is it possible to perform the Excel function "VLOOKUP" using Blue Prism? If so/not what is the approach to automate the VLOOKUP across 2 Excel data files?
Many thanks in advance.
how is it possible to assign values to rows of an added new column to a collection?
For example I have this situation:
Data di reg. Conto contropartita Definizione conto contropartita Importo in divisa interna Mese
Hello friends, (@sivagelli,@VJR )
I need to execute a query of type "Select from *..."
where the result is no rows selected because no rows match the criteria.
How to implement an action that performs an Sql querY?
How to perform the fact that the result of the query can be a null datatable...
Thank you so much @sheel.
Can you please share the regex expression that can be used to extract the word COMUNE only if preceeded and succeeded by ".;,", not by numbers or letters?
Thank you so much,
I should find a certain word in a string.
In particular I should find the word "COMUNE" inside a string, for example inside "BONIFICO DA COMUNE"
How is it possible to implement the regex formula?
I should find the word COMUNE only if preceeded and succeeded by ".;,", not by...