For sensitivity purposes I cannot show the actual query layout, however below I have sketched a rough layout:
This is the first query, and the result of this query, is then inner joined with another table from a different database on the Resource ID field in Table 1, which unfortunately has table calculations. Therefore, how should I approach trying to create this new query in Tableau?
Also it may or may not be useful, my company uses Oracle Hyperion to create these queries, therefore the local results are stored, and are easily joined with other tables. Unfortunately Tableau has no functionality to join worksheets together.
It's tough for me to determine how to handle the table calc without seeing the data but I wonder if you can't achieve the same results with LOD calcs instead?