Hi everyone,
I'm looking to replace alternate values in a column in using scripting. I've managed to select the values in the table but I'm struggling to find a way to replace them in just 1 column only.
This is my code so far:
Names Default To Here (1);
dt << new column ("selection", formula (sequence (1,2,1 )));
dt:selection << delete formula;
dt << select where(:1 & :selection !=1);
This is the table it creates:
![ASullivan_2-1610443139854.png ASullivan_2-1610443139854.png](https://community.jmp.com/t5/image/serverpage/image-id/29366i9FA435C6DEFBEB39/image-size/medium?v=v2&px=400)
I want to replace the values highlighted in the first column with 0. Any advice on how to accomplish this would be appreciated. Thanks!