Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
sharatj1989
Contributor III
Contributor III

Need to add new column for existing table which contain the combined data of two other column

I have a table Product_group, which contain 2 column

Product                         Product_2 

SPOT                                SPOT-T

FIX                                     ---------

TOM                                 ----------

SPOT                                 SPOT-T1

SPOT                                 SPOT-T2

i need to add third column DETAILED_PRODUCT which should look as below

  DETAILED_PRODUCT

         SPOT-T

          FIX 

        TOM    

       SPOT-T1

        SPOT-T2

where SPOT need to split in third column like where ever SPOT in Product column should be replace by Product_2.

Please help me with this. thank you

1 Reply