Einstein Analytics: "Fix" data with Update transformation

Scenario: there are changes in the business, based on the revision given, we need to update data stored in an existing dataset or create a new dataset.

Solution: use dataflow, in this scenario, we are going to use the update node, which is not so commonly used in the dataflow.

JSON behind update node

 "updateMaster": {

    "action": "update",

    "parameters": {

      "left": "getMaster",

      "update_columns": {

        "ID": "ID",

        "Desc": "Note"

      },

      "right": "getRevision",

      "left_key": [

        "ID"

      ],

      "right_key": [

        "Old_ID"

      ]

    }

  }

For the register node:

• Put the same Alias/Name to the master dataset if you want to overwrite it, the existing dashboard will work as per normal
• Use different Alias/Name from the source master dataset if you want to create a new dataset, you need to edit the existing dashboard to use the new dataset created. 

Reference:

• update Transformation