How to edit a dataset ?

Hugo_Wsld

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

Alexandru

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.

CoreyS

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!

Hugo_Wsld

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

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.