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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Join two tables

Meteor

Hi i have two tables casual leave in one table and sick leave in another table. I need a new table consolidating the both tables.

 

Based the names and dates. as shown in the sheet 3 of the attached excel file.

 

I have attached the sample data along with this!!!!!!!!!

 

Anybody help in this

 

Regards,

Yoganantha Prakash G P

Meteor

To get the output shown on sheet 3, you want to union the two tables together and not join them.  Within Alteryx you can use the Union tool to accomplish this. 

Alteryx Certified Partner
Alteryx Certified Partner

What you are really doing is UNIONing the data.  Please try using the UNION tool.  If you have questions about the union tool, there are examples that you can see within Alteryx if you click on the union tool in the favorites and open the OPEN SAMPLES hyperlink.  Also, there is a great interactive lesson in the ACADEMY.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

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

But i need the data by grouping of name

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@Yoga321 ,

 

There's a SORT tool to help you with that.  After the union, try to configure it by NAME ascending and Date Start ascending.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

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

The second table data is appending with first row data But I need to show in the Name wise list as like group by.

Meteor

Thanks Mark

Labels