Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

updating the field value

Rajag2
6 - Meteoroid

In the below screenshot when im updating the pnr_rec_loc_id column value it is not updating

4 REPLIES 4
BS_THE_ANALYST
14 - Magnetar

@Rajag2 either you need to untick the box 'Replace a specific string' .. or make sure the 'Specific String' matches:
Screenshot 2023-07-20 151539.png

 

JamesCharnley
13 - Pulsar

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.

Rajag2
6 - Meteoroid

It is not updating after unchecking the box

JamesCharnley
13 - Pulsar

@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.

Labels