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

Alteryx designer Discussions

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

Join two tables

Highlighted
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

Meteoroid

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

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