Hello,
In my datatable I have 6 data subsets (distinguished one another by Column X where each subset has a different letter "a", "b", "c", "d", "e" and "f"). How could I apply a script to all 6 subsets independently and get the 6 results of my script in one column?
Thank you in advance for your support!
Best
Claire
------
Script currently applied to entire datatable:
dt = Current Data Table();
dt << New Column("sumtempj", Numeric, Continuous, << Set Each Value(
As Constant(
ts = :"Rounded TempJ" << get values;
f_row = Min(Loc(ts,121));
t_idx = Index(f_row, f_row + 359);
sumtempj = Sum(ts[t_idx])-(360*121);
);
If(row() == f_row,
sumtempj,
,
.
);
)
);
