4 Replies Latest reply: Feb 26, 2010 3:21 PM by carlosmartinez1 RSS

    add new column

    clausere

      Hi, i'm new to qlikview, i try to create a new column as a concatenation of two strings present in my table.

      I load the table from a db Access as

      [ code ]

      select * from table

      [ /code ]

      and i create the new column with [ code ] LOAD value, concat(<field>, ', ') AS field_list FROM <table> GROUP BY value; [ /code ] but it doesn't work, the error refers to the table that it indicated as missing.

      thanks

        • add new column
          Shumail Hussain

          Hello!

          If you want to combine two fields then try & or + sign as per your requirement.

           


          LOAD
          Month,
          Year,
          Month&'-'&Year as MnYr
          FROM Sales;


           

          Concatenation is an operation that uses two tables and combines them into one. refer Help:

           

          tab1:

          Load * from file1.csv;

          tab2:

          load * from file2.csv;

          .. .. ..

          Concatenate (tab1) load * from file3.csv;

           

           

          Regards,
          Shumail Hussain