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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

If Not matching

Atom

Hi Team,

 

Started using alteryx today. Great to be joining the alteryx community.

 

I have two excel sheets with name field.   I need to take the name field from excel 1 and run it against excel 2 , if there is no match then i have to get that in output.

 

How do i do it..Help me on the same.

 

Baskar

Alteryx Certified Partner
Alteryx Certified Partner

@Baskarl,

 

Welcome to the community.  Here's how to solve the challenge:

 

1.  Use a JOIN tool

 

With inputs from the two Excel sheets (Left and Right), configure your join on the "NAME" fields.  There will be 3 output anchors (L,J,R) for Left unique, Join, and Right unique outputs.  If #1 is Left and #2 is Right, you will take the output from LEFT and you can use an output tool to write those names to another file.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels