How to edit a dataset ?

Options
Hugo_Wsld
Hugo_Wsld Registered, Frontrunner 2022 Participant Posts: 12 ✭✭✭✭

Hello everyone,

I exported an excel file and I would like to be able to add columns and rowsand calculations from Dataiku DSS as if I was in Excel !

Thanks !

Hugo

Best Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 Dataiker
    Answer ✓
    Options

    Hi Hugo,

    In DSS you can edit datasets by using a "Push to editable" recipe. You can read more about here .

    You can find it under Other Recipes, once the new dataset is created you can click on Edit and it will bring up page shows below.

    Screenshot 2021-09-22 at 15.03.15.pngScreenshot 2021-09-22 at 15.04.18.pngScreenshot 2021-09-22 at 15.04.30.png

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Hugo_Wsld
    besides Alex's great solution (thanks for accepting it btw!) I just wanted to provide you with this resource. Just incase you haven't accessed it yet, here is the Excel to Dataiku DSS Quick Start on the Dataiku Academy.

    This short hands-on tutorial is geared towards business analysts and other Excel users entirely new to Dataiku. It focuses on using the point-and-click interface and performing some of the most common Excel data processing and analysis tasks in a more efficient and scalable way with Dataiku.

    The tutorial introduces many of the essential capabilities of Dataiku by walking through a simple use case: connecting to, preparing, and analyzing CRM and web sales data.

    I hope this helps!

Answers

  • Hugo_Wsld
    Hugo_Wsld Registered, Frontrunner 2022 Participant Posts: 12 ✭✭✭✭
    Options

    Thanks for your very quick responses!

    I'll see the tutorials and try it all right away

    Is it possible to do calculations directly on the data table?

    Have a nice day!

    Hugo

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 Dataiker
    Options

    Hi, Not currently possible directly in the editable data table, where you can add rows, columns, and edit values there. Calculations needed can be done Prepare recipe.

Setup Info
    Tags
      Help me…