我有一个谷歌数据表,我想组织。有多个行,其值按列排序。我想根据列3-19中的值对行B进行排序。
我使用的算法如下:
=SORT(3:19, B3:B19, FALSE)
我的错误是:
Array result was not expanded because it would overwrite data in B2.
我看过这个Google支持页面,但无法让它正常工作。
我使用下面的update查询对我的表的描述列进行排序
update t
set t.weight=tt.new_weight
from SERVICE_OPTION as t
INNER JOIN
(select id, ROW_NUMBER() over (partition by COUNTRY_ID order by COUNTRY_ID, SERVICE_OPTION_TYPE_ID, description) as new_weight
from SERVICE_OPTION ) as TT
ON t.id = tt.id;
问题:例如,在附加在描述列中
你好,我有这段代码,用来对数据表进行排序。
Dim sortingIndex As Integer = orderby
Dim DataTableNew As DataTable = New DataTable
DataTableNew = dt.Clone
Dim query = (From c In dt.AsEnumerable Order By c.Field(Of String)(sortingIndex) Ascending)
query.CopyToDataTable(DataTableNew, LoadOption.Overwrite
我使用的是YUI2数据表。考虑以下场景。
var myColumnDefs = [
{ key:"A", label:"A", sortable:true},
{ key:"C", label:"C", sortable:true}
];
// i want to add this column after A.
myColumnDefs.push({ key:'B',label:'B'});