Alteryx Designer Discussions

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

Combination of Data

mmustkee
8 - Asteroid

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

5 REPLIES 5
Assaf_m
11 - Bolide

Hi,

 

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

 

Assaf_m_0-1613994554084.png

 

Qiu
19 - Altair
19 - Altair

@mmustkee 

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

mmustkee
8 - Asteroid

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
19 - Altair
19 - Altair

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

DelBen
SenTen
Can Pan
BenDen
EndSen
JanHen
SalSel
AstDst
MitKIT
mmustkee
8 - Asteroid

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

Labels