Combination of Data

Hi Taem,

I have attached table and I want to apply formula in Alteryx as '=IF(B2<A2,B2&"-"&A2,A2&"-"&B2)' where in B2 is "Das" and A2 is "One".

Thanks in Advance.

Mohammad Mustkeem

Output

Accepted answers

Hi,

Check the attached solution and let me know if it works for you

Hi,

Check the attached solution and let me know if it works for you

B2 and A2 are not numeric how can we do B2<A2?

Hi Qui,

Sorry about that. B2 or A2 is a cell number and yes we have to apply this on the text data.

Thanks,

Mohammad Mustkeem