Table Export

Hi,

 

I have a card that has the data table rows set to 50. When I export this out to either Excel | CSV, the results would only come back as 50 rows.

Does anyone know how to export the full table without removing the 50 limit on the table?

 

Warm regards,

 

 

 

Marc H.

Best Answer

  • Tomo
    Tomo 🟢
    Accepted Answer

    Hi.

     

    Add a line number using DataFlow.
    Use the card's Quick Filter and set it to the default 50 or less.
    To download all lines, unset Quick Filter or set it to 0 or more.

     

    ===

    DataFlowを利用して、行番号を追加します。
    カードのクイックフィルターを利用して、デフォルト50以下に設定します。
    全行ダウンロードするときは、クイックフィルターの設定を外すか、0以上にします。

Answers

  • Hi @Marc_H!

     

    If you're the owner of the dataset powering the card, probably the easiest way to do this would be to click through from the card to the dataset itself, then export from there. 

     

    Otherwise you'd have to remove the row limit on the card to get the full set from the card directly.

     

    Hope this is helpful!

  • Hi, Xerva,

    I'm looking for a solution on our participant tier access level to be able to do this.

    I need them to export the full table without having to remove our 50 limiter.

     

    Warm regards,

     

     

    Marc H.

  • I would recommend downloading the Domo plugin for Excel.  You can find it in the Admin tools section:2.png

     

     

    And then you can download the data set directly into Excel.  This also allows you to update the data on your Excel sheet by clicking a button.  

    1.png

     

     

     

  • Go to the Data Center. 

    Click on the Dataset. 

    Click the Wrench. 

    Export the full dataset.  

     

    Menu.png