5 Replies Latest reply: Dec 10, 2014 9:37 AM by Ivan Zdravac RSS

    calculation in load script creating field

      Hi all´,

       

      potentially easy solution, need to know how to calculate same value already in load script and by that creating a field.

       

      Example:  (Now I need the possibility to calculate the purple header during the load script)

      Field Header:         Order     |         Product      |         Customer       |     Qty. Products on Order     

      Field Content:          A                     small                   John                                      2

                                      A                      big                      John                                     2

       

       


        • Re: calculation in load script creating field
          barathiraja balashanmugam

          hi ivan,

          load

          order,

          product,

          customer,

          count(order) as Qty.Products on order

           

          from YOURSOURCE

          group by customer,product,order;

           

          hope it helps!

          Regards,

          Barathiraja

          • Re: calculation in load script creating field
            Anand Chouhan

            Hi,

             

            You are asking for table header for this you can use the variable or Calculated labels in the chart. Please share the data if have sample of this.

             

            Ex:-

             

            Qty * Product //As label

             

            Regards

            Anand

            • Re: calculation in load script creating field

              Okay guys,

              Example:  (Now I need the possibility to calculate the purple header during the load script)

              Red part I have already in my source

               

              TABLE XYZ:

               

               

               

               

              Field Header:         Order     |         Product      |         Customer       |     Qty. Products on Order     

              Field Content:          A                     small                   John                                      3

                                              A                      big                      John                                     3

                                              A                      small                    John                                    3

                                              B                      small                    Paul                                      1

               

              This works:

               

              TEST:
              LOAD
              A,
              count(A) as QTY_A
              RESIDENT TABLE_XYZ
              group by A;

               

               

              A     3

              B     1

               

              This doesn't work:

              TEST:
              LOAD
              A,
              count(A) as QTY_A,
              if(wildmatch(PRODUCT,'small'),count(A),0) as QTY_small,
              if(wildmatch(PRODUCT,'big'),count(A),0) as QTY_big
              RESIDENT TABLE_XYZ
              group by A;

               

               

              expected result  

               

              A   3    2   1

              B   1    1    0