Forum Discussion

GeoffBarrenger's avatar
GeoffBarrenger
Qrew Trainee
4 years ago

Clear out all Data in a Field - without deleting the field itself

Hello, I feel as though I'm overlooking something very simple here. Is there any way to clear out all data in a specific field, without deleting the field itself?  Or even better - clear out al...
Tables and fields
AndrewNelson's avatar
AndrewNelson
Qrew Cadet
4 years ago
I find that the easiest way to handle this sort of thing is to just export the table as a CSV (including the Record ID) and then add a blank column in Excel and re-import it.

------------------------------
Andrew Nelson
------------------------------
  • GeoffBarrenger's avatar
    GeoffBarrenger
    Qrew Trainee
    4 years ago
    I appreciate this cheap and cheerful suggestion! It works - not ideal once our image count goes up but works as expected.  I think eventually I will just move this to another table and do a table to table lookup as Mike and Mark have suggested - i can keep the publish data in a separate table and just wipe the table out monthly.  Thanks all for the great suggestions.

    ------------------------------
    Geoff Barrenger
    ------------------------------