Barb you could create a couple of Excel worksheets with dummy data demonstrating your issue. If you do this please mention the version of Tableau you are using.
Anyway, we're also going to need a few things clarified:
- What do you mean by 'live extracted'? It's one of the other.
- What do you mean by 'items'? Are these values in a single column? Or are you referring to a list of Column headers? What doesn't match?
Suggestion: Put a couple of Data Source filters on both the sources, say the top 1,000 rows. That way you won't be spending so much time waiting for queries.
I put together some dummy data. As you can see everything works, by placing the numbers side by side on the rows, it only shows the numbers that lie within both data sets.
My problem is with my actual data, it processes forever and just errors out eventually, sometimes it will sit for 10 min, others 1hr.
I was wondering if there was another way to get the same results?
How many unique values
are in your [Number] column
of your first Datasource (a big one)?
if they are at the 100K+ range, my suggestion would be
not using data blend with your Excel DS at all,
but export unique values from [Number] columns
of both datasource as CSV files
and do join them in Tableau post-hoc.
Hope this could help.
Yes, the database is very large. I have almost 100,000 rows just for Mar-16. I understand how to export the data and save a CSV, but can you explain more on how I would do a join or what you mean by that?
Sorry, I understand now. You're saying to create a set. I'll give that a try and report back later.