Combination of Data

[mmustkee]

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

[Assaf_m · Accepted solution]

Hi,

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

[Qiu]

@mmustkee 

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

[mmustkee]

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

[Qiu]

@mmustkee 
I mean how we suppose to compare these two data columns?

Del	Ben
Sen	Ten
Can	Pan
Ben	Den
End	Sen
Jan	Hen
Sal	Sel
Ast	Dst
Mit	KIT

[mmustkee]

Sorry About the confusion. Please consider column A and B as String and output also should be in string. and for comparison should be as per formula. Hope that helps. 

Thanks.

Mohammad Mustkeem