Table Export

Marc_H
Marc_H Member
edited March 2023 in Datasets

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 Contributor
    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!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • 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.

  • ST_Superman
    ST_Superman Domo Employee

    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

     

     

     

  • Tomo
    Tomo Contributor
    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以上にします。

  • Go to the Data Center. 

    Click on the Dataset. 

    Click the Wrench. 

    Export the full dataset.  

     

    Menu.png

    DataMaven
    Breaking Down Silos - Building Bridges
    **Say "Thanks" by clicking a reaction in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"