Method Community

I set up a field  'packsize' and set it as text. then I imported the data and figured out it should be numberic so I can do math against it.  Can I change the field type at this point? ifnot how do I correct this? canI setup new field and copy the data from one to the other?

Michele

Hello Michele,

     You would not be able to change a text field to a numeric field.  Two options come to mind.
 
  1. Do an import update.  Create your new field on the target table.  Export the RecordID and one other field that you can use as a unique reference field.  Copy and paste the packsize data to match the correct record using RecordID and your unique field.  Then do an import update.

   2. You can create a brand new screen.  The logic would be similar to the delete multiple records article in our Help Center.  You can use the Start Loop Through Grid action to find each record in the table.  Then you would have an Update Field on Table action that will take the value from your original field and put it in your new field.

The import update is the easiest to do and would take the least amount of time.

Greg