Does anyone know how to add a RecordID column in dataiku. I want to add serial number to each row.
Best Answer
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,617 NeuronWelcome to the dataiku community
Here is a link to a solution I’ve used from time to time.
see if any of those help. (Lots of different ways to do this)
Answers
-
Grixis PartnerApplicant, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 103 ✭✭✭✭✭✭Hey,
I think this plugin might suit your needs;
You can update each row with your serial number.
otherwise, with visuals recipes you can make rules on your column rows to add/modify a serial number. there are also python code steps.
Best
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,329 NeuronThe solution depends on where is your data (what kind of dataset: file based, SQL, etc) and what kind of recipe you want to use (visual, code, you don't care). Also how much data is in your dataset?
-
This worked!! I used windows recipe to add the record id column. Thank you for sharing these links @tgb417
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,617 Neuron
Excellent!!
(Thank you for marking my comment as your solution.)