need centralised table

Dilli Registered Posts: 3 ✭✭✭

Hi Team, Im building a python recipe where it update some amount filled for the next run I need to pick the updated value. As of now the initial value it picks from the input dataset....for the second how to update the remaining sum of amt for the second there any way I can maintain centralised table as a lookup table


Best Answer

  • 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,595 Neuron
    Answer ✓


    Not clear exactly what you are trying to do. In general we have some central projects we use to keep lookup tables, that are used by all projects.

    If it is a single value or a small number of values, you could also look at project variables, or instance variables as a place to keep such variables between the runs of your scripts.

    Either way, please share a few more details and others may be able to jump in with other ideas.


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

    Hi, @Dilli
    ! Can you provide any further details on the thread to assist users in helping you find a solution (insert examples like DSS version etc.) Also, can you let us know if you’ve tried any fixes already?This should lead to a quicker response from the community.

  • Dilli
    Dilli Registered Posts: 3 ✭✭✭

    Hi Corey,
    Thanks for the response,

    I have script which calculate assign some amt to each portfolio. once the first portfolio completed the second portfoli start with remaining amount. I couldn't find any common place where I can the keep track of this amount.


    I have data recipe where Im finding the optimum transaction for each portfolio.
    portfolio A allowed max value - $100

    once I complete this first portfolio solution, I might used $60.
    when I do the second iteration(portfoli B) i should start with remaining value $40. So this $60 i need to update in the input dataset(which I couldnt achieve as of now. i couldnt able to write to the input dataset). so I can refer it for the second iteration.

    Im new to dataiku.

Setup Info
      Help me…