9 Replies Latest reply on Jul 5, 2018 3:18 AM by Anuj Vaijapurkar

How to add multiple Custom SQL without keeping any relation between them

Anuj Vaijapurkar Jul 5, 2018 2:25 AM

Hi there,

I am using multiple PostgreSQL databases and need to write Custom SQL as pg functions aren't supported. I need to create multiple reports using different queries. These queries doesn't need to be connected with other queries or tables in the same tableau project. e.g. Query 1 gives me product report from db1 1 whereas Query 2 gives me user login/site traffic report from db2 which is not at all linked with the product report. At this stage I can either create a Product Report or a Traffic Report but not both in 1 tableau project. I need to have both under 1 project as I need to create a dashboard with multiple similar sheets. Currently, it forces me to set up at least 1 join between them, which is not possible.

How can I achieve this?

Thanks in advance.

Anuj

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.
Workgroups Database
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
Like Show 0 Likes(0)

Actions
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?
Like Show 0 Likes(0)

Actions
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)

Hi 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
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
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.
Workgroups Database
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
Cross-database Joins
Hope it helps.
BR,
bharat
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions
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!
Like Show 0 Likes(0)

Actions
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)

Hi 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
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
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.
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions