Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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.

binuacs
21 - Polaris

@wonka1234 I updated the workflow to reflect your change

binuacs_0-1680880546741.png

 

wonka1234
10 - Fireball

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

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

Labels
Top Solution Authors