In the below screenshot when im updating the pnr_rec_loc_id column value it is not updating
@Rajag2 either you need to untick the box 'Replace a specific string' .. or make sure the 'Specific String' matches:
Hi @Rajag2
It looks like you have the box ticked to replace a specific string that is no longer the value within the expression of the formula tool, so it can't find the value to replace and therefore isn't updating it. If you need to replace the whole string, then if you untick the 'replace a specific string' box at the bottom of the configuration pane then I'd expect that to work.
It is not updating after unchecking the box
@Rajag2 can you add a browse tool straight after the formula tool to look at when successfully running the app so we know it's definitely not working there. If you're inputting a string value with no ' ' in the app then try and update a specific value, making sure not to replace the ' ', but making sure the specific string you're replacing is a 100% copy and paste from the value within the expression.