Delete/flag rows... how to start

Mateusz
Mateusz Dataiku DSS Core Designer, Neuron 2020, Registered, Neuron 2021, Neuron 2022 Posts: 91 ✭✭✭✭✭✭

Hi All,

I am new to DSS and struggling to start. So any kind of help appreciate.

I have 2 columns, Company and Product group. What I want to do is to filter/keep only those rows in which I have my company's product group.
Attached a screenshot in excel with an example. Of course in real life I have like couple of thousands of rows and hundrets of product groups it diffucult to use simple "filter by value" or at least im not sure how to do it.

Thanks

Best Answers

Answers

  • Alex_Combessie
    Alex_Combessie Alpha Tester, Dataiker Alumni Posts: 539 ✭✭✭✭✭✭✭✭✭

    Hi,

    You can achieve that in 2 steps in a Prepare recipe:

    1. Flag rows where product group is from your company. That will generate a new "flag" column with 1 and empty values

    2. Remove rows where the flag column is empty

    For further information on how to go from Excel to Dataiku, this tutorial can be very helpful: https://academy.dataiku.com/latest/guide/analyst/excel-to-dss/index.html

    Cheers,

    Alex

  • Mateusz
    Mateusz Dataiku DSS Core Designer, Neuron 2020, Registered, Neuron 2021, Neuron 2022 Posts: 91 ✭✭✭✭✭✭

    Hi,

    I'm not sure if I understand. I mean I can flag product group based on my company name, but how could I add another flag I created in column D, so product groups that overlapps with those from my company?

    Thanks

  • Mateusz
    Mateusz Dataiku DSS Core Designer, Neuron 2020, Registered, Neuron 2021, Neuron 2022 Posts: 91 ✭✭✭✭✭✭

    Thank you for your help, but video is not working for some reason, is it an issue on my side?

    I'm getting this error: "There is an error. Please try again later.... More information"

    Also attached project - where I can find it?

    emate_0-1584103364196.png

    Sorry for the trouble & Thank you

Setup Info
    Tags
      Help me…