Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Joining two columns

koulos574
5 - Atom

Hi all,

Is there a way to join two columns where the specific fields contains number and letter ? Joining based on cells like this T5pL3C

Thank you all!

2 REPLIES 2
estherb47
15 - Aurora
15 - Aurora

Hi @koulos574 

 

Sure! The Join tool works on matching up almost any kind of data (spatial gets its own join tool called Spatial Match)

 

Let me know if that helps

 

Cheers!

Esther

Qiu
21 - Polaris
21 - Polaris

@koulos574 

Just add to @estherb47 comment.

  • Joining by columns having Double Data type might cause incorrectness.
  • Joining is case sensitive.
Labels