Concatenate in formula tool, but select the smallest value to be first.

[b86]

Hi all,

Hoping someone can help, I am still new to alteryx. Using the formula tool, I am simply trying to concatenate to columns, but I want to select the smallest of the values in each column to be placed as the first value in the concatenate. Any help would be greatly appreciated!

Column A     Column B       Concat

1000              999               9991000

998                1234             9981234

[bpatel · Accepted solution]

hi @b86 ,

you can try something like this in the formula:

hope it helps!

[b86]

Thank you so much!