2.2.4.3 Wtsunstack

1 Menu Information
2 Brief Information
3 Additional Information
4 Command Line Usage
5 X-Function Execution Options
6 Variables
7 Related X-Functions

Menu Information

Restructure : Unstack by Time Interval

Brief Information

Unstack dataset based on the specified time interval.

Additional Information

Minimum Origin Version Required: Origin 2024b

Command Line Usage

1. wtsunstack -r 2 time:=[Book1]Sheet1!C"Time" data:=[Book1]Sheet1!E"Original Value" bucket:=month start:=10 end:=20 label:="Month=MMM" timefmt:=MM/dd/yyyy;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Source Time	time	Input Range	<unassigned>	Specify the range that will be used as the time source of Time Interval
Source Data	data	Input Range	<unassigned>	Specify the range of data values to be unstacked.
Time Interval	bucket	Input int	0	Specify time interval. Option list: 0=year:Year 1=month:Month 2=week:Week 3=day:Day 4=hour:Hour 5=minute:Minute
Start Value	start	Input string		Specify the start time value for each unstacked group. When set bucket=year, you can set the specified date/ month as the start value. Format: MM/dd or JAN or 1(number of month). When set bucket=month, you can set the specified day of month as the start value. Format: 1-28. When set bucket=week, you can set the specified day of week index as the start value. Format:1-7. When set bucket=day, you can set the specified hour and minute as the start value. Format: HH:mm (13:00), 13, 1pm . When set bucket=hour, you can set the specified minute and second as the start value. Format: mm:ss. When set bucket=minute, you can set the specified number of seconds as the start value. Format: 0-60.
End Value	end	Input string		Specify the start time value for each unstacked group. When set bucket=year, you can set the specified date/ month as the end value. Format: MM/dd or JAN or 1(number of month). When set bucket=month, you can set the specified day of month as the end value. Format: 1-31. When set bucket=week, you can set the specified day of week index as the end value. Format:1-7. When set bucket=day, you can set the specified hour and minute as the end value. Format: HH:mm (13:00), 13, 1pm . When set bucket=hour, you can set the specified minute and second as the end value. Format: mm:ss. When set bucket=minute, you can set the specified number of seconds as the end value. Format: 0-60.
Output	ow	Output Worksheet	[<new>]<new>	Specify where to output result table.
Additional Label Row(s)	label	Input string		Add Label Rows for the year/ month/ date/ hour/ minute etc. value. For example: Year=yyyy\|Month=MMM
Output Date/Time Column Format	timefmt	Input string		Add Label Rows for the year/ month/ date/ hour/ minute etc. value. For example: yyyy-MM-dd HH:mm:ss yyyy-MM-dd HH:mm:ss.### yyyy-MM-dd hh:mm:ss tt dd/MM/yyyy dd-MM-yy MM/dd/yyyy MM-dd-yy yy/MM/dd yy.MM.dd dd.MM.yy yyyyMMdd dd-MMM-yy yyyyQq