Alteryx Designer Desktop Discussions

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

How to add 0 to number following a condition

roxana_castro96
5 - Atom

I have two data sets; one contains PO LN & the other contains Item; they both represent the same: a line on a PO; however, our vendor enters the lines different than we do sometimes. For instance, if our line is 10, they will either enter it as 10 OR 1, if our line is 330, they will enter it as 33, etc.

 

The rule I need goes as follow: if [PO LN] equals a number with digits different than 0, add a 0.

 

Case: If [PO LN] is 33, after formula, it will be 330.

1 REPLY 1
nagakavyasri
12 - Quasar

@roxana_castro96  try this:

 

Screenshot 2024-02-26 130323.png

Labels