Hi,
I wanna ask about 2 things.
-
I’m having talk with my friend related to coding and he told me there’s a script that I can do as if replacer so I don’t have to use if statement anymore and I can use script instead. Can anyone help me explore this more and is it possible to use it in uipath?
-
I’m doing an automation and it’s involving SQL Query. My select query has more than 5000 data, and I am using in statement. Example :
VarQuery = “Select * from table_A where Customer_ID in (Customer Number)”
Result of VarQuery rows count is more than 5000 data. When I use “select” it’s giving an error :
“Could not retrieve the result of the job execution. This might be because a message was too large to process.”
But when I use select top 5000, it’s not showing any error and the outputted data table are written to excel. Any explanation for this? Was it because of SQL “in” has limitation or the uipath has limitation? Thanks !!