Table Transformer sql replace function

[Jason Waller]

Hi Community, 

I'm using the SQL query feature in Table Transformer by Stiltsoft to try and rename the value in the summary column.  The first line is accepted but when I try to use the replace syntax, I get this error.  What am I missing here? 

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Jason Waller ,

Please use the following SQL query for the case:

SELECT *,

REPLACE ('Summary', "Define", "Add") AS 'Summary'

FROM T*

[Jason Waller]

Thank you for the quick response @Katerina Kovriga _Stiltsoft_ 

that has worked