8 Replies Latest reply: Nov 27, 2013 10:32 AM by Shelley Smith RSS

    How to combine two fields into one, in the load script?

    Shelley Smith

      In our sales data we have the STATE_FIPS code and the COUNTY_FIPS code as independent fields, but I need one field created that combines these two fields with a hyphen.  I've tried various things like STATE_FIPS & '-' & COUNTY_FIPS to show 10-029 for example, but can't get it to work.  The other thing that may be going on is QV could be seeing each of these independent fields as numbers rather than text.