Saturday, April 24, 2021

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": [
      "right_key": [

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. 


No comments:

Post a Comment

Page-level ad