-
1. Re: Joining or Blending two tables that are designed differently
Norbert MaijoorFeb 16, 2017 8:30 AM (in response to Brian Cachuela)
2 of 2 people found this helpfulHi Brian,
If all titles are the same you could reach your first option based on a union
If all titles must be maintained "as is" you could reach your second option based on a union.
A union in Tableau is explained here
-
2. Re: Joining or Blending two tables that are designed differently
Sherzodbek Ibragimov Feb 16, 2017 8:32 AM (in response to Brian Cachuela)Brian,
You can pivot both tables only if you can join them by common key. If it is not a big deal, can you add a common key to both tables then join them on that key and then pivot both tables and then you can get what you want.
-
3. Re: Joining or Blending two tables that are designed differently
Joshua Milligan Feb 16, 2017 9:25 AM (in response to Norbert Maijoor)Brian,
I agree with Norbert that a union is going to give you what you need. You may initially end up with a table that has all the rows of Table 1 and Table 2 instead of aggregated rows of Table 1 with rows of Table 2. But this should be fine because you can use aggregation in the Tableau viz to sum together all the 1 values to get the quantity.
You might find a calculation like this
[Quantity]
ZN(Sale) + ZN(QTY)
helpful to combine the Sale and QTY fields. Then treating that as a measure (specifically a SUM) in your view will give you correct results.
Hope that helps!
Joshua
-
4. Re: Joining or Blending two tables that are designed differently
Brian Cachuela Feb 16, 2017 12:07 PM (in response to Brian Cachuela)Thank you all for your response. I'm still working on it and made some progress, but I see where you are all going with this.