4 Replies Latest reply: Mar 23, 2018 7:16 AM by Sunny Talwar RSS

    Price group/interval match

    Rikke Skaar

      I would like to use the following code, but with the sum of the field assosiated with IntervalMatch. Is that possible?

       

      // PriceGroup:

      // LOAD * Inline [

      // Start,Stop,PriceGroup

      // 0,    99.99,    0-100

      // 100,    499.99,    100-500

      // 500,    999.99,    500-1000

      // 1000,    ,    Over 1000

      // ];

       

      // Join(PriceGroup)

      // IntervalMatch(CataloguePrice)

      // Load

      //     Start,

      //     Stop

      // Resident PriceGroup;

       

       

      // Drop Fields Start, Stop;