-
1. Re: Add multiple Excel sheets without joining them
Joe OppeltAug 29, 2016 3:12 PM (in response to Gerardo Lopez)
Works for me.
See attached.-
Two excel sheets.twbx 8.5 KB
-
-
2. Re: Add multiple Excel sheets without joining them
Joe OppeltAug 29, 2016 3:16 PM (in response to Joe Oppelt)
When you add new data source and select EXCEL, you specify the workbook, and Tableau links to it. then you get a list of the sheets in that workbook. Drag one sheet in. Then go to your worksheet. You have that sheet as a data source. Then do ADD NEW DATA SOURCE. Same deal. Drag the second sheet in, but not the first. Go to your worksheet. You have two separate data sources.
-
3. Re: Add multiple Excel sheets without joining them
Gerardo Lopez Aug 29, 2016 4:07 PM (in response to Joe Oppelt)Hi Joe,
That's what I've been trying to do, I can add the first sheet without a problem, but when I add try and add a new data connection, and select the same Excel file, Tableau will do weird things, in this 20second video, you can see it removing my Sheet 1 from my connection, instead of adding it as a new connection. In Tableau 8, there was a large orange button that i would have to click to goto the sheet, is there an equivalent in v10?
-
4. Re: Add multiple Excel sheets without joining them
Kathryn Bridges Aug 29, 2016 6:02 PM (in response to Gerardo Lopez)1 of 1 people found this helpfulHi Gerardo,
After you add Sheet 1 in, you'll need to actually go to a sheet. So once Tableau previews Sheet 1 in Excel, click on "New Sheet". On that page, click on the Data tab on the top ribbon, then "New Data Source".
In your video, you are just overwriting one source over another.
Thanks,
Katie
-
5. Re: Add multiple Excel sheets without joining them
Gerardo Lopez Aug 30, 2016 10:20 AM (in response to Kathryn Bridges)Hi Katie,
I tried that as well, I first added sheet1 with Alex,Billy,Carol. Then once I added Sheet2, the names are replaced with David,Eric,Felicia. I know by dragging sheet2 over sheet1 I was replacing it, but if I don't do that, then I'm forced to join the connections, if I remove the sheet, it will remove it from the first connection and then I'm stuck where I was before.
-
6. Re: Add multiple Excel sheets without joining them
Joe OppeltAug 30, 2016 10:29 AM (in response to Gerardo Lopez)
In that video, after you add NAME to the sheet, it goes too quickly. What is your next step?
At that point you should click on the DATA tab and select ADD NEW DATA SOURCE.
Just do it that way.
-
7. Re: Add multiple Excel sheets without joining them
Gerardo Lopez Aug 30, 2016 10:32 AM (in response to Joe Oppelt)1 of 1 people found this helpfulSorry about that Joe, I was trying to keep the video brief for everyone's sake, after adding names:
Click the Data Source Tab
Click Add
Select the Excel File
Drag Sheet2 over Sheet1 on the newly created "Test (2)" connection.
This last step is what's frustrating me, I don't know how to get rid of Sheet1 from this connection.
-
8. Re: Add multiple Excel sheets without joining them
Gerardo Lopez Aug 30, 2016 10:36 AM (in response to Gerardo Lopez)Joe, I just tried Data, New Data Source like you said, and that works. Arghh... Ok, I see what I was doing wrong now. The Add button that I was using should be relabeled as "Add Join" or something else.. Thanks for all your help Joe and Katie!
-
9. Re: Add multiple Excel sheets without joining them
Joe OppeltAug 30, 2016 10:38 AM (in response to Gerardo Lopez)
-
10. Re: Add multiple Excel sheets without joining them
Joe OppeltAug 30, 2016 10:41 AM (in response to Gerardo Lopez)
OK, you got it.
for the record, I remember going through this when we went from V8x to V9. that's where the interface change happened.
-
11. Re: Add multiple Excel sheets without joining them
Gerardo Lopez Aug 30, 2016 10:48 AM (in response to Joe Oppelt)Gotcha, I'm going from v8 to v10
-
12. Re: Add multiple Excel sheets without joining them
Joe OppeltAug 30, 2016 10:52 AM (in response to Gerardo Lopez)
-
13. Re: Add multiple Excel sheets without joining them
Evangeline White Sep 13, 2016 10:01 AM (in response to Gerardo Lopez)If it's any consolation, I spent over an HOUR trying to figure this out yesterday before finally giving up. I couldn't even figure out how to ask the question the right way until this morning. Thanks for the post!