5 Replies Latest reply: Dec 13, 2015 9:40 PM by jagan mohan rao appala RSS

    Joining / Merging / Concatenating a field in the same table

      Good Afternoon Qlikview community,

       

      Hopefully this is an easy one to solve. I have a table with several fields in and two of them hold simular data. I would like to merge these two fields together so they are one.

       

      Here are some of the fields

       

      Town

      City

      Departure

      Arrival

      Company Departure

      Company Arrival

       

      I would like Company Departure and Company Arrival as Company. so I thought it would be something like

       

       

      TravelPlan:

      LOAD

      Town,

      City,

      Departure,

      Arrival,

      Company Departure AS Company,

      Company Arrival AS Company


      FROM...

      But that did not work.

       

      Any help would be highly appreciated.

       

      Thanks again

       


      Mark