2.2.4.3 Wtsunstack


Contents

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

Related X-Functions

wunstackcol,wtspivot