Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have a column field called source/medium for which has different channels. However, I am stuggling to create a group for (FB organic and facebook/paid FB Paid .
For instance I want to make sure that any source/medium field that contains facebook or Facebook or FB, and paid or Paid is grouped as FB Paid and any source/medium field containg facebook or Facebook or FB and organic or Organic is grouped as FB Organic and else as others.
Someone can help me in this?
Thank you in advance
Solved! Go to Solution.
@Anonymous , Try a new column like
if ( (search("Facebook",[source/medium],,0) >0 || search("FB",[source/medium],,0) >0 ) ,
SWitch( true() ,
search("paid",[source/medium],,0) >0 ,"FB Paid",
search("organic",[source/medium],,0) >0 ,"FB Organic ",
"Others"
), "Others")
@Anonymous , Try a new column like
if ( (search("Facebook",[source/medium],,0) >0 || search("FB",[source/medium],,0) >0 ) ,
SWitch( true() ,
search("paid",[source/medium],,0) >0 ,"FB Paid",
search("organic",[source/medium],,0) >0 ,"FB Organic ",
"Others"
), "Others")