Join two tables

[Yoga321]

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

[Tom216]

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. 

[MarqueeCrew]

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

[Yoga321]

But i need the data by grouping of name

[MarqueeCrew · Accepted solution]

@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

[Yoga321]

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

[Yoga321]

Thanks Mark