Error in Query using OLE DB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-09-19 06:35 AM
I am using OLE DB connection in BluePrism.
I am trying to execute following Query:
"SELECT * DISTINCT [User ID ] FROM [Sheet1$]"
But it is throwing following error message:
Internal : Could not execute code stage because exception thrown by code stage: Syntax error (missing operator) in query expression '* DISTINCT [User ID ]'.
Please help me to solve this error.
Thanks
------------------------------
Mohini Shelke
RPA Developer
vElement It
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-09-19 11:17 AM
------------------------------
Saumitra Sharma
Consultant
EY
Indian/Christmas
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-09-19 11:39 AM
------Original Message------
Mohini, SQL Query is wrong it should be SELECT DISTINCT [User ID ] FROM [Sheet1$]...U can use either Distinct or * both not together
------------------------------
Saumitra Sharma
Consultant
EY
Indian/Christmas
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-09-19 11:47 AM
Select * from [Sheet1$]
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-09-19 01:31 PM
Thanks & Regards,
Mohini Shelke
RPA Developer, vElement IT,
------Original Message------
U can use this but this will delete the duplicate data permanently only unique data will be there...delete dups from (select *, row_number() OVER ( partition by [User ID] order by [User ID]) as rn from [Sheet1$]) dups WHERE rn > 1
Select * from [Sheet1$]
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-09-19 03:03 PM
There should be space between 1 and Select you have missed the space it should be rn > 1 Select * from [Sheet1$]
------------------------------
Saumitra Sharma
Consultant
EY
Indian/Christmas
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-09-19 06:42 PM
I tried with space also,still getting same error.
------------------------------
Mohini Shelke
RPA Developer
vElement It
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-09-19 06:19 AM
------Original Message------
Hi,
There should be space between 1 and Select you have missed the space it should be rn > 1 Select * from [Sheet1$]
------------------------------
Saumitra Sharma
Consultant
EY
Indian/Christmas
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
18-09-19 05:57 AM
Can you post your vbo here. Let me check.
------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
18-09-19 10:51 AM
Thanks & Regards,
Mohini Shelke
RPA Developer, vElement IT,
------Original Message------
Hi Mohini,
Can you post your vbo here. Let me check.
------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------
