2 Replies Latest reply: May 4, 2015 8:00 AM by Shiva Reddy RSS

    Joint or Alias

    Kenny Hua

      Hello everyone,

       

      Actually, I try to know exactly what it's mean and how to use in qlikview:

       

       

      (oracle SQL)

      Select

          D.field1,  <-----

          field2,

          field3

      from

          Data D  <--- they put an alias to use with the first field

       

      AS I Said above, I need an equivalent in qlikview.

       

      Regards

        • Re: Joint or Alias
          balkumar chandel

          Hi ,

           

          I think you have a query which is extracting data from SQL

           

          you can use join here as well and in preceding script just alias the column names as required.

           

          if you want you can use

          Select

              field1,  <-----

              field2,

              field3

          from

              Data

           

          if you dont need to join with any table

          (we use Alias name in Sql for columns which have same name in both the tables (joined with))

           

           

          Thanks

          BKC

          • Re: Joint or Alias
            Shiva Reddy

            see this,

             

            Select

                field1 as uraliasname,

                field2,

                field3

            from

                Data D