213794_zh-TW

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
);