213794_zh-CN

liliconcom

Re：根据另一个单元格值更新多个单元格

1. 您的新列是Character列，因此它们只能具有Nominal Modeling Type。 
2. 你使用的是分号“;”在IF（）比较结束时，而不是逗号“，”。  IF（）函数的结构是：

   IF( comparison,
        // If True
        icalculation;
        calculation;
        ,
        // If not true
        comparison,
        // if True
        calculation;
        calculation;
        ,
        // Else
        calculation;
   ;
        

   这是对代码的修改

3. Names Default To Here( 1 );
   dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
   dt << New Column( "NewAge", Character );
   dt << New Column( "NewAge2", Character );
   dt << New Column( "NewAge3", Character );
   Current Data Table( dt );
   For Each Row(
    If(
     dt:Age == 14,
      dt:NewAge = "Blah";
      dt:NewAge2 = "Blah2";
      dt:NewAge3 = "Blah3";, 
   
     dt:Age == 15,
      dt:NewAge = "yay";
      dt:NewAge2 = "yay2";
      dt:NewAge3 = "yay3";, 
   
     dt:Age == 16,
      dt:NewAge = "yo";
      dt:NewAge2 = "yo2";
      dt:NewAge3 = "yo3";,
     "0"
    )
   );

    

根据另一个单元格值更新多个单元格

当我执行以下操作时，它会更新我没有创建if的其他单元格。 

如何更新我在for行和if函数中调用的那些？ 

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << New Column( "NewAge", Character, Continuous );
dt << New Column( "NewAge2", Character, Continuous );
dt << New Column( "NewAge3", Character, Continuous );
For Each Row(
 If(
  dt:Age == 14,
   dt:NewAge = "Blah";
   dt:NewAge2 = "Blah2";
   dt:NewAge3 = "Blah3";

   dt:Age == 15;,
  dt:NewAge = "yay";
  dt:NewAge2 = "yay2";
  dt:NewAge3 = "yay3";

  dt:Age == 16;,
   dt:NewAge = "yo";
   dt:NewAge2 = "yo2";
   dt:NewAge3 = "yo3";
 ),
 0
);