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

hi @b86 ,

you can try something like this in the formula:

hope it helps!