-
1. Re: How to add multiple Custom SQL without keeping any relation between them
kumar bharat Jul 5, 2018 2:44 AM (in response to Anuj Vaijapurkar)Hi Anuj,
Without a relation between the tables the metadata(workgroup data) will not be there.Please check this.
Identify the relationship between the data to get meaningful dashboard
***Alternatively (second approach) ***
you can export the data to excel sheet and add a new column called as key in the excel sheets,the key column would be common between the sheets.
You can use the key column to join.
Hope it helps.
BR,
bharat
-
2. Re: How to add multiple Custom SQL without keeping any relation between them
Anuj Vaijapurkar Jul 5, 2018 2:51 AM (in response to kumar bharat)Thanks for replying Bharat. In my case, I can't have any key column as you suggested since
1. the data keeps changing and I need to pull the latest data every time I run the report so can't have Excel in between the steps
2. they are completely different schema having nothing in common so no relation
So does that mean that I will end up creating multiple projects?
-
3. Re: How to add multiple Custom SQL without keeping any relation between them
Paul Cawford Jul 5, 2018 2:56 AM (in response to Anuj Vaijapurkar)1 of 1 people found this helpfulHi Anuj,
Maybe I'm missing something as PostgreSQL is not something I use. But within tableau can you not just create a new data source in the same workbook i.e. Data --> New Data Source (or CTRL+D)
This will give you two unrelated data sources (which can be blended if required)
Regards,
Paul
-
4. Re: How to add multiple Custom SQL without keeping any relation between them
kumar bharat Jul 5, 2018 3:03 AM (in response to Anuj Vaijapurkar)Hi Anuj,
Ideally i dont agree with you that there is no relation between the tables.Like i told
Without a relation between the tables the metadata(workgroup data) will not be there.Please check this.
Identify the relationship between the data to get meaningful dashboard
Secondly
It cannot be a case where the columns in the table will change may be the data gets changed.
You can still add a key column.For ex: serial number or report id or dashboard id.
Add this key column in all the excels and generate a dashboard.
You can do it in single workbook---multiple sheets.
I don't know what you mean by project here,I guess you are new to tableau
** cross data base joins
Hope it helps.
BR,
bharat
-
5. Re: How to add multiple Custom SQL without keeping any relation between them
Anuj Vaijapurkar Jul 5, 2018 3:02 AM (in response to Paul Cawford)Hi Paul,
Many thanks for replying back. I gave your solution a quick try and I feel it will work in my case. I will explore it further and will put my findings here.
Many thanks once again.
-
6. Re: How to add multiple Custom SQL without keeping any relation between them
Anuj Vaijapurkar Jul 5, 2018 3:05 AM (in response to Anuj Vaijapurkar)Hi Paul,
It solved my problem to a great extent. Thank heaps once again!
-
7. Re: How to add multiple Custom SQL without keeping any relation between them
nikher verma Jul 5, 2018 3:14 AM (in response to Anuj Vaijapurkar)1 of 1 people found this helpfulHi Anuj Vaijapurkar ,
Yes you can do that and you will have two different data source .As there's no relation between these two data source you cant make a worksheet where you can use the fields or attributes of both table .But you can build your report on different sheets ;keep in mind you cant link these two tables .And if you want to put it together use a dashboard .
Write the first SQL query first make the worksheet then in order to add another data source and you are done .
-Nikher Verma
-
8. Re: How to add multiple Custom SQL without keeping any relation between them
Anuj Vaijapurkar Jul 5, 2018 3:16 AM (in response to kumar bharat)Hi Bharat,
First of all, many many thanks for quick turn around.
You are right, I'm new to Tableau (have been working only for 3-4 months).
Yes, there is no relation between the datasets which I'm trying to create as these are complete different information pieces stored in one database and the client wanted to have them under single dashboard. So, in my case, Paul's solution worked for me as I created multiple copies of the same connection to create multiple queries and have put them in 1 dashboard.
-
9. Re: How to add multiple Custom SQL without keeping any relation between them
Anuj Vaijapurkar Jul 5, 2018 3:18 AM (in response to nikher verma)Perfect! Did the same Nikher and it worked as I wanted.
Thanks heaps for the solution.