Forum Discussion

kwmacd's avatar
kwmacd
Cloud Apps
10-11-2023
Solved

How to allow users to download a table with 300+ columns

I have been given a SQL query that has a column for each day of the year, and about 50 rows with different business metrics. I have also been told that I need to host this query in Sisense for users ...
  • HamzaJ's avatar
    10-12-2023

    Hello kwmacd 

    Is there a specific reason why your sql has a horizontally (365 columns) orientated table instead of a vertical one? The last one would make it way easier. Furthermore I think that sisense has a max on the amount of columns. I dont know if it is possible to include 365 individual fields.

    I am unfamiliar with your dataset, however I would advice to make it have a vertical orientation. For example

    Instead of

    KPI | day 1 | day 2 | day 3 | day x

    KPI #1 | 1 | 1 | 1 | 1

    go for this

    KPI #| Day

    KPI # 1 | 01-01-2023

    KPI # 1 | 02-01-2023

    Then you can easily add those two fields and let users download it or send it via the report manager

    Hamza