3 Replies Latest reply: Jan 29, 2018 6:48 AM by Ankusha Dongre RSS

    Dual function

    arvind pednekar

      Dual function

       

       

      Hi All,

       

      Can some one Tell me where can i use Dual function in Scrip

      Give me some Example script

        • Re: Dual function
          Kundan Sharma

          Dual() combines a number and a string into a single record, such that the number representation of the record can be used for sorting and calculation purposes, while the string value can be used for display purposes

          Syntax:

          Dual(text, number)

          Load dual ( NameDay,NumDay ) as DayOfWeek inline

          [ NameDay,NumDay

          Monday,0

          Tuesday,1

          Wednesday,2

          Thursday,3

          Friday,4

          Saturday,5

          Sunday,6 ];

          The field DayOfWeek

          can be used in a chart, as a dimension, for example.In a table with the week days are automatically sorted into their correct number sequence, instead of alphabetical order.

          • Re: Dual function
            ABHIJITH NAIR

            Refer the Link for the same:

            How to use- Dual()

            • Re: Dual function
              Ankusha Dongre

              The Dual function is used to keep values in order.

              For example:

               

              Load Dual(day,number) Inline[

              day,number

              monday,1

              tuesday,4

              wednesday,2

              ];

               

              OUTPUT:

              monday

              wednesday

              tuesday

               

               

              here you can see that the days are arranged in sorted order based on the number field.