Add a repeated string numeric times into a formula string

[hlau117]

 I want to add 'ENDIF' multiple times to the right end of a formula string. I am using a formula tool with PadRight but the output formula string does not change. Any suggestions/ work around would be really helpful.

Attached is the workflow

[AbhilashR · Accepted solution]

Hi @hlau117, the value of length defines the length of string, and not occurrence of the string you are looking to pad. Per Alteryx's official documentation:

As a workaround, I have artificially generated ENDIF using generate fields and concatenated it using the summarize tool, which I have added back to the original formula in a formula tool.

Please mark this post as solution accepted if it answers your questions.

[hlau117]

Thanks, solution works