Add New Field In column

inam — Mon, 11 Mar 2024 05:22:09 GMT

Hello ,

utmccn,
utmcct,
utmcmd,
utmcsr,
utmctr,
utmgclid,

if(utmccn='(direct)','Direct',
if(wildmatch(utmcmd,'EMAIL'),'Email',
if(wildmatch(utmcsr,'WM'),'WM',
if(wildmatch(utmcmd,'pwa','BPN','APN','Chat','Bot','SMS','Chatbot') OR wildmatch(utmcsr,'MA','Bpush','WM','BPNMA','invitereferrals','TCblog') , 'MA',
if(wildmatch(utmcmd,'organic'), 'Organic',
if(wildmatch(utmcmd,'cpc','cpl','cpm','cpv','cpd','cpvl') OR wildmatch(utmcsr,'*Optimidea*','*google*','*Google*','*facebook*') OR wildmatch([Campaign Name],'DOM SEM - Jan ''24','INT SEM - Jan ''24'), 'Paid',
if(wildmatch(utmcmd,'referral','qrcode'),'Referral',))))))) as PROD_TYPE,

so i create one column PROD_TYPE in this i have field
'Direct'
'Email'
'WM'
'MA'
'Organic'
'Paid'
'Referral'

but my requirement is want to create one more field Non_Paid
Direct + Email + MA + Organic + Referral is 'Non_Paid'
Non Paid + Paid is 'Total'
from column "Lead Source" = 'Cross Sell' where the "Product Type" = 'Forex' is 'Cross sell'
one empty field is 'Personalisation'

so i want my PROD_TYPE column field look like this
'Direct'
'Email'
'WM'
'MA'
'Organic'
'Paid'
'Referral'
'Non_Paid' (Direct + Email + MA + Organic + Referral)
'Total' (Non Paid + Paid)
'Cross sell' (column "Lead Source" = 'Cross Sell' where the "Product Type" = 'Forex')
'Personalisation' (Blank)

Re: Add New Field In column

Nagaraju_KCS — Mon, 11 Mar 2024 06:30:42 GMT

You can write in preceeding or resident load

IF(Match(PROD_TYPE, 'Direct', 'Email', 'MA', 'Organic', 'Referral'), 'Non_Paid',
IF(Match(PROD_TYPE, 'Non Paid', 'Paid'), 'Total',
IF(Lead Source = 'Cross Sell' and Product Type = 'Forex', 'Cross sell',
IF(LEN(TRIM(PROD_TYPE))=0, Personalisation, PROD_TYPE)))) as New_Field

topic Re: Add New Field In column in Qlik Automate

Add New Field In column

Re: Add New Field In column