Start Free Trial

Alteryx Designer Desktop Discussions

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

Add a repeated string numeric times into a formula string

hlau117
6 - Meteoroid

 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

2 REPLIES 2
AbhilashR
15 - Aurora
15 - Aurora

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:

AbhilashR_0-1585885976209.png

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.

AbhilashR_1-1585886260757.png

 

 

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

 

hlau117
6 - Meteoroid

Thanks, solution works

Labels
Top Solution Authors