827225_zh-CN

liliconcom

填写缺失值

我有一个症状奇怪的转置

当转置执行时，列中的第一个单元格是“批次 0”，而所有后续单元格都是空的，我想将这些单元格填充为“批次 1”。有什么线索可以告诉我该怎么做吗？

自动化和脚本回复：填写缺失值

这是一个可以完成你想要的操作的小脚本

If( :"RSC TCANEAL/ furnace/ 5139"n[1] == "Batch 0",
	Try(
		:"RSC TCANEAL/ furnace/ 5139"n[Current Data Table() << get rows where(
			Is Missing( :"RSC TCANEAL/ furnace/ 5139"n )
		)] = "Batch 1"
	)
);

这是一个完整的例子

Names Default To Here( 1 );
New Table( "Example",
	Add Rows( 25 ),
	New Column( "RSC TCANEAL/ furnace/ 5139",
		Character,
		Set Values(
			{"Batch 0", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "",
			"", ""}
		)
	)
);

If( :"RSC TCANEAL/ furnace/ 5139"n[1] == "Batch 0",
	Try(
		:"RSC TCANEAL/ furnace/ 5139"n[Current Data Table() << get rows where(
			Is Missing( :"RSC TCANEAL/ furnace/ 5139"n )
		)] = "Batch 1"
	)
);

回复：填写缺失值

Jim，谢谢。我修改了它，以便从第 4 列开始迭代，并且只对除第一行之外的空列进行操作。

colList1 = Data Table( "Transpose of History" ) << get column names( string );<BR /><BR />For( i = 1, i <= N Cols( Data Table( "Transpose of History" ) ), i++,
	If( Column(colList1[i])[1] == "Batch 0" & Col N Missing( As Column(colList1[i]) ) == NRow()-1,
	Try(
		Column(colList1[i])[Current Data Table() << get rows where(
			Is Missing( As Column(colList1[i]) )
		)] = "Batch 1"
	)
)
);