Concatenation of columns using sql query in uipath

Help
1

Hi Team,

I have tried to convert my excel as DB using connection string and connect activity in uipath.
When I’m trying to concatenate two columns using sql query, I’m getting the error like “Execute Query: ERROR [42000] [Microsoft][ODBC Excel Driver] Undefined function ‘concatenate’ in expression.”

Help me with the concat sql query to use in uipath.

Thanks!

2

Hello @Soundharya

I think you have to use CONCAT instead of concatenate…

3

@Soundharya

Try this
SELECT Concat(column1 ,column2) AS column3
FROM table;

Thanks,
Suresh J

4

I’m using this query “Select Concat(Measure,Name) As ColumnTest from [Tablename$]” and I’m getting error like ERROR [42000] [Microsoft][ODBC Excel Driver] Undefined function ‘Concat’ in expression.

5

I have tried Concat as well, but still getting the same error “Undefined function concat”.

6

@Soundharya

Are those two columns of string data type?

Just do this and see

Select column 1 + column 2 from…

1 Like
7

@Lahiru.Fernando
Thanks for your reply!
As said, I have tried with + operator and I’m getting the same error "Undefined function concat”…
“Select Concat (Measure+Name)AS ColumnTest from [Tablename$]”

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.