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 

[Clara Vega _Simpleasyty_]

Hi @Jason Waller  

Have you tried doing this with Simple Table app? For this kind of case, it can be much simpler.

Instead of writing a full SQL REPLACE() query, you could use a calculated column to map the value you want, then hide the original column and rename the new one. Simple Tables supports calculated columns, column hiding, and renaming headings directly in the table setup, so for a straightforward change like replacing "Define" with "Add", the setup is usually easier to manage.

Something like this should work:

=summary == "Define" ? "Add" : summary

So the idea would be:
create the calculated column, hide the original Summary column, and rename the new one back to Summary. For a simple value replacement, that is often easier than maintaining a SQL query.

That said, if the use case involves more advanced text transformations, Table Transformer may still be the better fit.