1 of 1 people found this helpful
The options are
1) Export your Sharepoint Lists into CSV files, then UNION them together.
2) Make extracts (files), then apply the recipe by Jonathan :
3) As s last resort, do blend your Sharepoint List datasources
using a Scaffold datasource as a Primary. By a Scaffold datasource
i mean a special hand-made datasource (it could be Excel or CSV)
which is a cross-product (contains every combination) of all unique values
of all the dimensions common in your Secondary datasources (SP Lists).
Think of it as a cube -- with cells populated by aggregates from your Secondary.
Hope it could help a bit.
Thanks so much Yuri! Let me try option 2 and 3 and see if I can make one of those work. Really appreciate the direction.
Mark, you're welcome.
Please reply if you have any questions / follow-ups.
I'm in a situation similar to yours - I need to union 2 SharePoint Lists... and there doesn't seem to be a way to do in the Tableau. How did you make out on your situation?
I feel your pain Mark. If Tableau is capable of connecting to Microsoft's Excel or CSV files, it should be able to connect to SharePoint right? Ha! Not so. My guess is that there may be some unresolved proprietary issues going on between the two companies, but that is just a hunch. Maybe newer versions of Tableau Desktop will finally provide this functionality.