4 Replies Latest reply: Mar 4, 2011 6:10 AM by Chris Hopkins RSS

    Create a new field from 2 fields in the load scrip with the data limited?

    Chris Hopkins

      Hi

      I want to create a new field in my script from 2 other fields but i also want to limit the data .

      i.e.

      DealNumber

      DealName

      I want to combine these 2 fields which is easy enough:

      DealNumber & '-' & DealName AS [Deal Description],

      I only want it to show DealNumber >=200050 and DealNumber <=200020 or DealNumber =900000 and call it [Meal Deals]

      Can anyone please tell me how i would write this into the script?

      Thanks