Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.