Join two tables

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

Book1.xlsx

Datasets

Accepted answers

MarqueeCrew

@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

All comments

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703