Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jun 8, 2020, 4:27 AM

Table with 2000 columns what would be the better approach

Hi All,

 

I have a requirement in which i am using 2 tables. Transaction table with 2000 columns and around 4 years of data ( 20M Records ). The other table is the security matrix table with 100000 Records.

But for my report i need only 30 columns and 2 years of data which would come under 9M records .  We tried both the below scenarios and found the performance was very bad.

 

Approach 1 :

Creating a view out of the Table with those 30 columns and for the latest 2 years of data. performance was very slow in loading the report is it bcoz of the view ?

 

Approach 2 :

Using the custom sql in tableau and going for an extract, But due to increase in number of records extract is failing after 2 hours on server.

 

So can anyone please suggest what would be the right and suitable approach for this scenario.

 

Thanks & Regards,

Pavan K

1 answer
  1. Hari Ankem (7x Tableau Ambassador)
    Jun 8, 2020, 5:19 AM

    Have you applied any filter when you are using the custom SQL, which I assume is for the 30 columns only, to filter the data for 2 years? If you are not putting a WHERE clause to filter the data in the query, add a data source filter through which you can limit the number of records.

Write an answer...
0/9000