5 Replies Latest reply: Dec 24, 2014 4:29 AM by Thomas van Zoggel RSS

    Loading only max values

    Thomas van Zoggel

      Hi guys,

       

      I am loading an SQL table with values for Date, Type and Amount. Sometimes I have multiple values for the same Date and Type, but with different amounts. For each Date and Type combo, I'm looking to load only those records that have the Max amount.

       

      Date     Type     Amount

      x           a          10

      y           a          12

      z           a          8

      z           a          15

       

      So in this table I only want z, a, 15 to load. Any way I can simply do this by altering my Load script maybe?