Nope this will not work as oledb has a limitation to return only first 255 columns and we already tried this approach.
This solution might work with more rows but not with more than 255 columns
When we are merging 2 collections having1 common column and when you try to combine both collections using Merge Collections Action. Will be getting below error- No matter whether output collection is same or different.
Internal: Could not execute code stage because exception thrown by code...
Hi all,
We have a requirement to read data from excel having 1001 colums.
Due to large excel data (7k rows and1001 cols) we are using oledb to retrieve only filtered records into bp collection (max of 10 records) but as OLEDB has a limitation of getting only first 255 cols.
Request you to...
I have a requirement to identify first empty column out of the filtered records.
Excel 1= 7k rows and 1k columns
Upon applying filter criteria it will be max of 3 to 4 rows with 1000 columns.
For 1 employee If am not able to find empty columns for filtered records(3 to 4) from excel 1 then...
What is the ID column you are referring to?
How would i know under which column itself that value exists in the excel cell.
Out of 7000 rows and 1000 column my
cell value =" 0013589" might exists in any excel cell( .
How would i know in which column?
Here i want to find exact cell co...
At run time - i have no idea in which column (under which header) this id is available.
Then to find the index i need to iterate through all 7k rows and 1k columns to get the column name or header.
Correct -If i understood your sol. approach incorrectly.
Hi All,
I have 8 different excels and each with 7k rows and 1000 columns
I want to find a employee id in all excels and get all the column names where this employee id is available.
Ex: employee id might be available 0 or any number of times in any cell in any excel.
Points to be noted:.
1. In...
In Bluerpism -I have selected parameter 1 type as Number and respective parameter in VBA has been declared as Variant( changed from integer to variant).
When i pass parameter 1 value as 3000 or 4000 to Run Macro action, its working fine.
When i pass parameter 1 value as 20000, then am getting...
Q)Can anyone help me in passing parameters to macro from blueprism?
When i tried calling the macro function in VBA ( and passing parameters), its absolutely working fine.
When tried passing parameters from blueprism, am getting below error:
Internal : Could not execute code stage because...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.