Hi Team,  In Data feed raw data, Order_value column has multiple values inside the Array.  Can you please help me with Query to sum up array.  for instance:    

Thanks @leocwlau , @Jennifer_Dungan  for your valuable suggestions & codes. I am able to get numbers matching with Adobe WS.

Thanks @leocwlau , I tried it, dint got any output. However if you see below screen shot,  ",1," ",202," are appearing at the begging of the event list...  I just want to recite my query again here...  trying to build visit level segment having event3, Order event & v13 in the post_v13 because v13 i...

Hi @leocwlau , both event3 & Order event 1 fire on order confirmation page, so it's okay about there placement. I think there is something needs to be added in the below visit segment like adding event list or eVar instances..  I have tired it but getting output mismatch error.WHERE    (Post_Vis_Hig...

Here you  go... trying to match e3 Adobe workspace count 465,  but getting 538..SELECTSUM(CASE WHEN (Post_Event_List_Text LIKE '%,202,%' AND Post_Event_List_Text LIKE '%,1,%' AND Post_cart_abandonment_campaign_eVar13 ='Cart Abandonment campaign') THEN 1 ELSE 0 END) as e3 FROM    table-name-maskedWHE...

Thanks @Jennifer_Dungan  for your prompt response. I have been to those sites & have used it. However, still my SQL query is not giving the desired output.

Hi All, I am trying to create a visit segment to filter out visit having event3(,202,), event 35(,234,) and eVar13 exist. @Jen

Thanks @leocwlau ,  We don't see  visid_high, post_visid_low, visit_num, visit_start_time_gmtfrom data feed raw data file,  however we have"Post_Vis_High_Identifier,    Post_Vis_Low_Identifier,    Visit_Number,    Visit_Start_Gmt_Timestamp"  so I am using the same.  This giving me ...

Hi Team, Can you please help me Creating Visit Level segment for Data feed raw data? for instance:  Segment visits having eVar9 = "campaign"