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}

Hi @Jason Waller ,

Please use the following SQL query for the case:

SELECT *,

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

FROM T*