1 Reply Latest reply: Nov 25, 2010 4:59 AM by karls007 RSS

    Help with load script

    Chris Hopkins

      Hi,

      In my load script i need to load a field in as a different name but only if another field ='yes'. Below is an example of my fields..

      EntryMethod,
      SaleDescription,
      DiscountGroup,
      DiscountAmount,
      DiscountApplied,
      DiscountLine,
      PriceOverride,
      AuthorityId,
      PromotionType,
      MinimumAge,

      What i want to do is to load DiscountGroup AS [Stock Movement Reason Code] but only where PriceOverride = 'yes'

      This should only give me PriceOverride DiscountGroups.

      Can someone tell me how to do this please?

      Thanks