The append transformation

The append transformation allows us to append the data from multiple datasets and combine them to form a single dataset. In Salesforce, events and tasks are two different objects used to represent activities logged by the sales representative. If we want to merge these two objects and derive all the activities, we can use the append transformation in Wave Analytics to visualize collective metrics:

    {
"EventsDataset": {
"action": "edgemart",
"parameters": {
"alias": "Events"
}
},
"TasksDataset": {
"action": "edgemart",
"parameters": {
"alias": "Tasks"
}
},
"AppendTasksandEvents": {
"action": "append",
"parameters": {
"sources": [
"Events",
"Tasks"
]
}
},
"RegisterActivitiesDataset": {
"action": "sfdcRegister",
"parameters": {
"alias": "AllActivities",
"name": "AllActivities",
"source": "AppendTasksandEvents"
}
}
}

The following diagram pictorially represents the JSON dataflow file using block diagrams:

The preceding code is an example JSON in a dataflow.json file. This combines datasets of events and tasks and forms a new dataset named AllActivities.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset