Alteryx Designer Discussions

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

What does replace a specific string do?

Jkiddin10
6 - Meteoroid

So i recently created a workflow where i needed to use modify sql in dynamic input and i had to replace a specific string which was the sheet name in order for it to work. But what does replace a specific string do?? am i replacing the sheet name with something? if so, what is it?

Jkiddin10_0-1634869176956.png

 

3 REPLIES 3
apathetichell
16 - Nebula

replace a specific string - does just that. It conducts a find & replace and replaces a value BUT KEEPS THE UNMATCHED REMAINDER. update value or something will overwrite everything.

 

so:

 

10+5 - where specific string 5 is replaced by 10 will give you 20.

10+5 - where update value is replaced by 10 will give you 10.

Jkiddin10
6 - Meteoroid

but in the case of my included photo, what am i replacing my string with? it just says replace Qtr but i never input anything to replace Qtr with

apathetichell
16 - Nebula

are you replacing that specific sheet name with the other sheetnames?

Labels