270023_zh-CN

liliconcom

回复：新专栏问题

您正在将摘要消息发送到表。  括号中的所有内容都是摘要消息的参数，例如组，范围。

 

您不能只添加新列-这不是摘要消息的有效参数。但是，它是一条消息，您可以将其发送到表。  因此，首先创建摘要表，然后向其发送新的列消息：

dtSumm = DataTable("data") << Summary( . . . );
dtSumm << NewColumn( . . .);

新专栏问题

Data Table( "Data" ) << Summary(
 Group( :Row, :Col ),
 Range( :Data Trace ),
 New Column("ABC",formula(:Range(Data Trace)*1E15)),
 Freq( "None" ),
 Weight( "None" )
);

我正在尝试创建一个新列，如上所示，其中我将其上一行中的列乘以1E15。该表已创建，但新列“ ABC”未显示。也许我的语法有问题。任何想法最欢迎。谢谢马克

脚本编写回复：新专栏问题

大卫，您好，谢谢您的回复。作为一个完整的初学者，我对语法并不那么熟悉。我已经在下面复制了整个脚本。它允许您选择多个文件，为每个文件创建一个表，然后将数据连接到单个表中，然后从该热图图创建一个摘要表。在汇总表中，“范围”是热图中变量的颜色。但是，我想将值乘以1E15，并且还可以在图表上放置标题。我只是不确定如何执行此操作，但感觉它应该只需要一行或两行，或者在某些内容前添加* 1E15。令人沮丧的是，我想做的事是如此简单，但要成为一名程序员似乎很难（我想我只是在语言/语法上苦苦挣扎）

 

names = Pick File(
 "Select Data File",
 "$DESKTOP",
 {"Text Files|txt;csv", "All Files|*"},
 1,
 0,
 "Data",
 multiple
);


nitems = N Items(names);


path = substr(names[1],2,Contains(names[1],"/",-1)-1);


For(i=1, i <= nitems, i++, names[i] = substr(words(names[i],"/"),7));


names = Files In Directory(path);

Data = New Table("Data", Character, Nominal);
col = New Column( "DC Bias Volt", Numeric, "Continuous", Format( "Best", 12 ) );
col = New Column( "Data Trace", Numeric, "Continuous", Format( "Best", 12 ) );
col = New Column( "File" );
col = New Column( "Row" );
col = New Column( "Col" );


For(i=1, i <= nitems, i++, 

dt = Open(Concat(path, names[i]),
 
 columns(
  New Column( "DC Bias Volt", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "Data Trace", Numeric, "Continuous", Format( "Best", 12 ) ),
  New Column( "Memory Trace", Numeric, "Continuous", Format( "Best", 12 ) )
   ),
 Import Settings(
  End Of Line( CRLF, CR, LF ),
  End Of Field( Tab, CSV( 0 ) ),
  Strip Quotes( 1 ),
  Use Apostrophe as Quotation Mark( 0 ),
  Use Regional Settings( 0 ),
  Scan Whole File( 1 ),
  Treat empty columns as numeric( 0 ),
  CompressNumericColumns( 0 ),
  CompressCharacterColumns( 0 ),
  CompressAllowListCheck( 0 ),
  Labels( 1 ),
  Column Names Start( 6 ),
  Data Starts( 7 ),
  Lines To Read( 101 ),
  Year Rule( "20xx" )
  
 )
 );
 Metadata = Words(names[i], "_");
 Die_Row = Substr( Metadata[6], 2, 2 );
 Die_Col = Substr( Metadata[6], 5, 2 );
 dt << New Column( "File", Numeric, Nominal );
 dt << New Column( "Row", Character, Nominal );
 dt << New Column( "Col", Character, Nominal );
 :File << Set Each Value( i );
 :Row << Set Each Value( Die_Row );
 :Col << Set Each Value( Die_Col );
 If(Metadata[1] == "CSV",
 Data << Concatenate( dt, "Append to First Table" ));
 Close(dt,NoSave);
 
);

Data Table( "Data" ) << Summary(
 Group( :Row, :Col ),
 Range( :Data Trace ),
 Freq( "None" ),
 Weight( "None" )
);


Graph Builder(
 Size( 1112, 704 ),
 Variables( X( :Col ), Y( :Col ), Color( :Name( "Range(Data Trace)" ) ) ),
 Elements( Heatmap( X, Y, Legend( 5 ) ) ),
 SendToReport(
  Dispatch(
   {},
   "Col",
   ScaleBox,
   {Min( 0 ), Max( 60 ), Inc( 1 ), Minor Ticks( 0 )}
  ),
  Dispatch(
   {},
   "Col",
   ScaleBox( 2 ),
   {Min( 0 ), Max( 60 ), Inc( 1 ), Minor Ticks( 0 )}
  )
 )
);