SS&C Blue Prism Community

Try str([Column 1] )=''------------------------------Daulat Ram------------------------------

Basically it will remain the same for empty columns------------------------------Daulat Ram------------------------------

Select * From [Table1$] Where [invoiceID]= "1234"  AND ([Column1] <>'' OR [Column2] <>'' OR [Column3] <>'') will filter for InvoiceID and at least one of Columns having valueTable1: is the name of the Sheet in excel file where you are checking for In...

I want to Insert into Sheet 2 based on filter condition in sheet1When I use HDR=YES; in connection string it gives null in Place of alphanumeric rowsSample configuration which I am Using:Connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Sourc...

Hi,I am having the same issue where Select Query in OLEDB is giving blank value where the datatype is not number in excel column.I have tried all the above solutions but none seems to work. Any working solution for this issue?Thanks in advance.------...