Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Filter data based on distinct row names

Solved!
Leonardo
Level 2
Filter data based on distinct row names

Hi Dataiku,

I have thousands of rows and about 20 columns with info. In the first column, I have patient names, some appearing more than once. I am interested to filter data based on distinct patient names, so that all patients appear only once. 

It should be fairly straightforward but I am not that experienced in DSS. 

Any ideas?

Thank you,

Leonardo


Operating system used: windows

0 Kudos
1 Solution
Manuel
Dataiker
Dataiker

Hi,

Have a look at the Group recipe, it allows you to indicate the keys to group by (e.g. customer name) and then specify the aggregations.

See this video as an introduction https://www.youtube.com/watch?v=DGAuPmAgWZo.

If you are new to DSS, you should consider completing one of our free academy courses to get you started, https://academy.dataiku.com/path/core-designer.

I hope this helps.

 

 

View solution in original post

The Group recipe is one of the most commonly used visual recipes in Dataiku. It allows you to aggregate the values of some columns by the values of one or more keys. This video is part of the "Basics 102" course on Dataiku Academy: https://academy.dataiku.com/path/core-designer/basics-102 CHECK ...
0 Kudos
1 Reply
Manuel
Dataiker
Dataiker

Hi,

Have a look at the Group recipe, it allows you to indicate the keys to group by (e.g. customer name) and then specify the aggregations.

See this video as an introduction https://www.youtube.com/watch?v=DGAuPmAgWZo.

If you are new to DSS, you should consider completing one of our free academy courses to get you started, https://academy.dataiku.com/path/core-designer.

I hope this helps.

 

 

The Group recipe is one of the most commonly used visual recipes in Dataiku. It allows you to aggregate the values of some columns by the values of one or more keys. This video is part of the "Basics 102" course on Dataiku Academy: https://academy.dataiku.com/path/core-designer/basics-102 CHECK ...
0 Kudos