Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sharatj1989
Contributor III
Contributor III
‎2019-01-02 06:22 AM

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

349 Views
0 Likes
1 Reply