community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

need help

Asteroid

Hi,

 

I  have IDs in below format. I am trying to get 100 CDS ID's in to the format below. So i am searching an excel spreadsheet and filtering If MGRID field contains(anyone of the 100 CDS ID's). So please post the syntax.Thnks

 

abcccc
xyzddd
cyeyyy
xxxzzz
yyyyyy
zzzhhh
sssABC
gggDEF
Alteryx Certified Partner

Hey @Pinky

 

You're going to need to give more information.

 

Start by sharing your original datasource and an example of how you want it to look.

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Asteroid

I have 100+ Id's in Excel spreadsheet. So i am searching an excel spreadsheet and filtering id IF ManagerID field contains(Anyone of the 100 ID's).

 

Hope you understand!

Not sure I understand. Are you trying to compare two data sources and looking for an outer join?

Alteryx Certified Partner

Ahh yes, I do understand.

 

The find and replace tool is the one to use here:

 

Manager.PNG

Labels