-
1. Re: Joining data from different files with same columns
Jim DehnerMay 1, 2018 4:01 AM (in response to Andy Spink)
Good morning
see the link below
the Wildcard union is would be the way to go
Wildcard Union on tableau server
If you haven't seen the new Tableau Prep - it would also be a good choice
https://onlinehelp.tableau.com/current/prep/en-us/help.html#prep_get_started.html
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
2. Re: Joining data from different files with same columns
saurabh.c.0 May 1, 2018 4:03 AM (in response to Andy Spink)You can do the union in tableau if all 3 files have same columns.
-
3. Re: Joining data from different files with same columns
Andy Spink May 1, 2018 4:08 AM (in response to saurabh.c.0)I didn't think it was possible to union sheets from different google sheet files?
I can only connect them using joins, which isn't giving me the right result.
-
4. Re: Joining data from different files with same columns
saurabh.c.0 May 1, 2018 4:15 AM (in response to Andy Spink)https://onlinehelp.tableau.com/v10.1/pro/desktop/en-us/help.html#union.html
You need to use the wildcard option
-
5. Re: Joining data from different files with same columns
Andy Spink May 1, 2018 4:22 AM (in response to saurabh.c.0) -
6. Re: Joining data from different files with same columns
Jim DehnerMay 1, 2018 4:32 AM (in response to Andy Spink)
did you try to put them into the same folders
see the link Union Your Data
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
-
7. Re: Joining data from different files with same columns
Andy Spink May 1, 2018 5:26 AM (in response to Jim Dehner)All sorted. Thanks for the assistance!
-
8. Re: Joining data from different files with same columns
Jim DehnerMay 1, 2018 7:17 AM (in response to Andy Spink)
If it solved your issue please mark the response correct to close the
thread.
Jim
On Tue, May 1, 2018, 7:34 AM Andy Spink <tableaucommunity@tableau.com>