Quick Script to Add data to new column for all rows.

Go to solution
jared_wentzel
Kilo Contributor

‎08-28-2015 07:29 AM

I am looking for the easiest and quickest way to add a value to a new column for all rows in a table. This only needs to be a onetime script and I will be populating the same value 'NRFUS' to the same column 'Member Firm' on the same table 'u_assignment_assistance' for all rows. Any thoughts?

0 Helpfuls
  • 1,349 Views
1 ACCEPTED SOLUTION

Go to solution
Robert Beeman
Kilo Sage
In response to Robert Beeman

‎08-28-2015 07:51 AM

Even easier might be to:


  1. go to the list view of the table
  2. right click on the column headers
  3. click Update All
  4. click OK to accept changing all records
  5. input 'NRFUS' to the Member Firm field (without changing anything else)
  6. click Update

View solution in original post

5 REPLIES 5

Go to solution
jared_wentzel
Kilo Contributor

‎08-28-2015 07:55 AM

Excellent! Thanks guys!


0 Helpfuls