Split Data without Subfield Function

[rajni_batra]

Hi Folks,

We have Data Mentioned as INPUT / OUTPUT  in screenshot below,

we have email and segment (comma separated),

I am able to achieve OUTPUT with sub-field function but this increases the no of rows,

i have 30 Million records and after using this technique no of records got increased to 210 Million,

Is there any other way to achieve same output.

[#2]

Pull the data as you have, then resident from the imported table using a specific aggregated function (sum, count, average, etc.) to summarize the data then drop the original data set.

Hope this helps.

Pravesh

[rajni_batra]

Segments are comma separated in a single filed (a,b,c,d),

I want segments to be plotted separately(

a

b

c

d

)

and then compute sum(email) on that for each segment,

I hope i am able to explain the issue now.