Unstack Table Variables
Distribute values from one table variable to multiple table variables in the Live Editor
Description
The Unstack Table Variables task lets you interactively unstack, or distribute, values in a table or timetable from one variable to multiple variables. The task automatically generates MATLAB® code for your live script.
Open the Task
To add the Unstack Table Variables task to a live script in the MATLAB Editor:
On the Live Editor tab, select Task > Unstack Table Variables.
In a code block in the script, type a relevant keyword, such as
unstackortable. Select Unstack Table Variables from the suggested command completions.
Examples
Unstack Table Variable Using Live Editor Task
This example shows how to unstack values from one variable in an input table and distribute them to multiple variables in an output table by using the Unstack Table Variables Live Editor task.
First, load a table that contains estimated influenza rates along the east coast of the United States. The table has a variable with flu rates and another variable indicating whether the rates are for the Northeast (NE), Mid-Atlantic (MidAtl), or Southeast (SE) regions. (These data come from the Google Flu Trends.)
load fluRate
Add the Unstack Table Variables task to your live script. Unstack the Flu Rate variable so that the output table has variables named NE, MidAtl, and SE, containing flu rates for those regions.
To group the data by month, select the
Group bymenu item below theMonthvariable in the task.To select the names of the output variables, click the radio button
Names of new table variablesabove theRegionvariable. For each unique value inRegion, there is a corresponding variable in the output table.To distribute values from the
Flu Ratevariable into theNE,MidAtl, andSEvariables in the output, click the radio buttonValues in new table vaeiablesaboveFlu Rate.
Related Examples
See Also
join | Join Tables | stack | Stack Table Variables | unstack