How to do a partial replace in a dataset?

Options
WHM
WHM Contributor

Time card data gets updated very frequently and is in a parent child relational database. I want to keep that structure at the base level in Domo. The tables are work summary and work detail. The details are deleted and recreated in the applicaiton when the time card is updated. How can I update the work summary record in Domo and replace the work detail records?

Best Answer

  • zcameron
    zcameron Domo Employee
    Answer ✓
    Options

    It sounds like if you pull the summary data as one data set and the detail data as another, you can then use fusion or a dataflow to join the two tables together. The join can then happen automatically whenever either dataset is updated. Is that the behavior you're looking for?

Answers

  • kshah008
    kshah008 Contributor
    Options

    Hi all,

     

    Can anybody help @WHM with their question?

     

    Thanks!

  • zcameron
    zcameron Domo Employee
    Answer ✓
    Options

    It sounds like if you pull the summary data as one data set and the detail data as another, you can then use fusion or a dataflow to join the two tables together. The join can then happen automatically whenever either dataset is updated. Is that the behavior you're looking for?

  • kshah008
    kshah008 Contributor
    Options

    @WHM, did zcameron's reply help answer your question?

This discussion has been closed.