insert a specific value from picklist to another field

insert a specific value from picklist to another field

Hi,

I have a pick list -- Status --  field and which contains several values like -- Duplicate, Review and  No Need .
What I am trying to do is insert 'No Need" value from the lookup field Status to   CD_Status   field of  Chanel_Database form. 


Can you please help me to fix . Below is my code


if (input.Update_primarychannel  !=  null)
{
    insert into Chanel_Database
    [
        Added_User = zoho.loginuser
        CD_ChannelType = "0.1"
        CD_market_id = input.Update_MarketID
        CD_Network = input.Update_primarychannel
        CD_networkID = input.Update_PriChannelID
        CD_tvId = input.Update_TVID
        CD_TV_Station = input.Update_CD_Station

        CD_Status =  "No Need" 
        
    ]