This method of combining data utilizes a stacking function that is suitable when the datasets being combined use the same data column names for the same questions (e.g. different waves of the same study). New questions are fine, so long as the data column name is not the same as an old question from a previous wave.
This tutorial shows how to combine data using a simple data process. There are two types of data processes in Protobi-- a simple data process or an asynchronous data process. A simple data process operates only on data tables in the same project, and return a single modified table.
Add data tables
Before creating a data process, add date tables and upload files for each dataset that will be combined.
Data processing code
The code combines datasets by appending rows of data vertically.
Declare a variable for each data table that will be combined (e.g. var W1,) and assign a value by referring to the respective data table name (e.g. data[“wave1”]).
Enter the variables in the Protobi.stack_rows function array.
Add the return rows statement to recall the result of the stacking process.
var W1 = data["wave1"] var W2 = data["wave2"] var W3 = data["wave3"] var W4 = data["wave4"] var rows = Protobi.stack_rows([W1 ,W2, W3, W4]); return rows;