3 Replies Latest reply: Nov 11, 2016 2:07 AM by Thomas Kaltmüller RSS

    Distinct in Load

    Thomas Kaltmüller

      Hello,

       

      I load the following fields:

       

      Inventory No,

      Storage Place,

      Document No

       

      I don't want duplicates in the Inventory No.

       

      Can someone help me?

        • Re: Distinct in Load
          Chanty 4u

          Hi ,

           

          chechk below sample example:

          LOAD sid,

              FirstValue( name) as name,

              FirstValue( sales) as sale,

              FirstValue( profit) as pro,

               FirstValue(Year) as year,

              FirstValue( Month) as month

          FROM

          [C:\Users\admin\Downloads\New Microsoft Office Excel Worksheet.xlsx]

          (ooxml, embedded labels, table is Input)

          Group by sid;

           

          sidnamesalesprofitYearMonth
          123wrr45806992014jan
          345rere5476652015feb
          346aa5486662016mar
          347fe5496672014apr
          348aa5506682015may
          349rere5516692016jun
          350fsf5526702016jul
          355sf5536712014aug
          355f5546722015sep
          355sf5556732016oct
          350sf5566742014nov
          355sffsw5576752014dec
          356wrr5586762015jan
          357sfsf5596772016feb
          358wrr5606782015mar
          359tg5616792016apr
          351sf5536712014aug
          352f5546722015sep
          353sf5556732016oct
          354sf5566742016nov
          355sffsw5576752014dec
          356wrr5586762015jan
          357sfsf5596772016dec
          358wrr5606782015mar
          359tg5616792016apr

           

          ddd.PNG

          • Re: Distinct in Load
            Thomas Kaltmüller

            Thanks.

            • Re: Distinct in Load
              Payal Shah

              Do this "Inventory No" has different "Storage Place" and "Document No"?

              Can you elaborate on your requirement?