3 Replies Latest reply on Jul 9, 2018 3:46 PM by Deepak Rai

how to connect multiple excel sheets that have the same column names

oscar tolosa Jul 6, 2018 1:43 PM

Hello,

I get variable data from multiple users in excel sheets.

They all have the same columns and thousands of lines.

How do I add these to my workbook so the union is done vertically instead of horizontally?

Best regards,

1. Re: how to connect multiple excel sheets that have the same column names

Deepak Rai Jul 6, 2018 1:48 PM (in response to oscar tolosa)

HI OScar,
Couple of Options

Please Follow This:

Union Your Data

You may also try to do this in Tableau PREP.
Connect Tableau Prep to Your Data

Thanks
Deepak
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: how to connect multiple excel sheets that have the same column names

Matt Lutton Jul 7, 2018 3:40 PM (in response to Deepak Rai)

Agreed - take a look at the link and google tableau union for more examples. Can also be done in the newer Prep tool. Happy analyzing!
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
3. Re: how to connect multiple excel sheets that have the same column names

Deepak Rai Jul 9, 2018 3:46 PM (in response to oscar tolosa)

Hi Oscar,
If your Problem was Resolved then you can close Thread .
Thanks
Deepak
Like Show 0 Likes(0)

Actions

Tableau Community Forums