Is there any way to delete multiple datasets at once?

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @user13374 

     

    Yes, you can go to the data center and list all of your datasets. You can then mutli-select the datasets by clicking the checkbox on the left side of the row (you can hover over the icon on the left side to reveal the checkbox). 

    Screen Shot 2020-04-21 at 2.08.23 PM.png

     

    Once you finish selecting the datasets you want to delete you can select the gear icon and then select delete.

     

    Screen Shot 2020-04-21 at 2.17.22 PM.png

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • java cli has a command delete-dataset which will allow you to delete one dataset at a time.  if you want to delete a list of them implement a FOR LOOP in your scripting tool of choice.

     

    https://knowledge.domo.com/Administer/Other_Administrative_Tools/Command_Line_Interface_(CLI)_Tool

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Hi @user13374 

     

    Yes, you can go to the data center and list all of your datasets. You can then mutli-select the datasets by clicking the checkbox on the left side of the row (you can hover over the icon on the left side to reveal the checkbox). 

    Screen Shot 2020-04-21 at 2.08.23 PM.png

     

    Once you finish selecting the datasets you want to delete you can select the gear icon and then select delete.

     

    Screen Shot 2020-04-21 at 2.17.22 PM.png

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • user048210
    user048210 Domo Employee

    hi @jaeW_at_Onyx 

    Can you please help on how we can execute the commands inside FOR LOOP. I tried something like below:

    FOR /F %a in (ids.txt) do @java -jar domoUtil.jar -script test.domo %~a

     

    But the script fails to parse arguments and hence the command fails.

     

    Thanks,

    Anurag  

  • you would want to generate a script file (like a .bat) file that contains one row per command you want to run.

     

    ... so i wrote a script that produces the following csv:

     

    connect -s 'yourServer' -t 'yourAccessToken'
    dataset-run-now -i 197200
    dataset-run-now -i 197126
    dataset-run-now -i 197203
    dataset-run-now -i 129139
    dataset-run-now -i 129139
    dataset-run-now -i 132406
    dataset-run-now -i 197269
    dataset-run-now -i 197183
    dataset-run-now -i 197268
    dataset-run-now -i 197273

     

    then i can just execute the file

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
This discussion has been closed.