Trying to append a word "jira" via the Rename by Regex transformations

Hello @krishvoor,

Welcome to the forum!

The variable you put in the replace field looks weird… Can you take a screenshot of the query, I don’t need the query but the name:
image

Regards

hi, have you tried the concat function? I’m using BMC Postreg SQL so not sure how your syntax goes, but it may be something like this.

SELECT
  CONCAT ( t."mem_total", ": JIRA") AS mem_total
FROM

cheers,

2 Likes