ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Is there a formula other then PADLEFT that just puts the 0 to the front of a string?

wonka1234
10 - Fireball

Padleft requires one to define how many characters to go left , how can I always just put a 0 to the front of a string no matter the length?

14 REPLIES 14
wonka1234
10 - Fireball

@danilang @TheCoffeeDude  ah i got it. I think i need to adjust my workflow to give an option to change field types in an analytic app. 

TheCoffeeDude
11 - Bolide

Use a macro to accomplish this.

binu_acs
21 - Polaris

@wonka1234 I updated the workflow to reflect your change

binuacs_0-1680880546741.png

 

wonka1234
10 - Fireball

@binu_acs  thank you! is there anyway to make the.. fields included in the multi row field selectable by interface? That would be very useful as It would allow a user to select which fields they want to make string.

wonka1234
10 - Fireball

@binu_acs  just seeing if you had a chance to help me make it dynamic interface.

Labels
Top Solution Authors