A consequence VALUESPLIT

46 views
Skip to first unread message

Samy AlNaimy

unread,
Feb 24, 2022, 7:13:15 AM2/24/22
to Warp 10 users
Hi,

I have a case where I should split a time series by its value as a consequences.

Example:
Input: a GTS with these values
100 0
200 0
300 0
400 1
500 1
600 0
700 1
800 1
900 1
1000 0
1100 0

Output: [100,200,300],[400,500],[600],[700,800,900],[1000,1100]
or any correspondent output.

How can I achieve that without iterating the GTS values manually?

Xavier MARIN

unread,
Feb 28, 2022, 10:27:47 AM2/28/22
to Warp 10 users
Maybe something like that?

// Create a new GTS with ten values
NEWGTS
'test name' RENAME
{ 'label0' '42' 'label1' 'foo' } RELABEL
100 NaN NaN NaN 10 ADDVALUE
400 NaN NaN NaN 10 ADDVALUE
500 NaN NaN NaN 6 ADDVALUE
700 NaN NaN NaN 6 ADDVALUE
800 NaN NaN NaN 6 ADDVALUE
900 NaN NaN NaN 6 ADDVALUE
1000 NaN NaN NaN 4 ADDVALUE
1100 NaN NaN NaN 4 ADDVALUE
200 NaN NaN NaN 10 ADDVALUE
300 NaN NaN NaN 10 ADDVALUE
'split-label'
VALUESPLIT <%
'gts' STORE
$gts LABELS 'split-label' GET TOLONG 'v' STORE
[ $gts $v mapper.replace 0 0 0 ] MAP 0 GET
%> F LMAP

Reply all
Reply to author
Forward
0 new messages