Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

How to pull certain information into separate columns

Xiaobai
5 - Atom

Hello,

 

We would like to pull certain information (Project Name and Entity Name) from a field. The field has plenty unnecessary information and descriptions. Please see the example below:

 

Field: "Bonnie and Peter did a proposal for Project Apple on Monday to Company ABC" or "Memo for Berry for DEF"

 

The output we want:

 

Field 1Project NameEntity Name
Bonnie and Peter did a proposal for Project Apple on Monday to Company ABCAppleABC
Memo for Berry for DEFBerryDEF

 

We have the full list of the project name and entity name with us in a separate excel file. Currently we are using the formula below for each project but it is a little bit time consuming, I am wondering if there is an easier way to solve this issue.

 

IF Contains([Field 1], "Apple") THEN "Project Apple" ELSE "" ENDIF

4 REPLIES 4
binuacs
20 - Arcturus

@Xiaobai If you the list of separate Project and Entity you can use the Find and replace tool

binuacs_0-1645695032942.png

 

Xiaobai
5 - Atom

Thanks a lot @binuacs! This solves my issue!!

atcodedog05
22 - Nova
22 - Nova

@Xiaobai 

 

Solution authors are Happy to help : )

If the solution author's response helps please don't forget to mark it as a solution.

Cheers and have a nice day!

Xiaobai
5 - Atom
Thanks for the reminder! Just marked it as solved.
Labels