core.noscript.text
Hi,
I have a large dataset with data like this:
How can I shrink this dataset to something like this:
please note that this email could be any email, not just the one person.
Thanks.
Solved! Go to Solution.
Hi @wonka1234
One way of doing this
@wonka1234 Definitely note a better one but just try something different. 😁
@Felipe_Ribeir0 i forgot to mention i have other columns before these delegate columns and they are not showing up as null. anyway to not do this?
@wonka1234
Something like this? You have some columns that you want to keep
INPUT
OUTPUT
@Felipe_Ribeir0
thank you, this seems to be working! although how come only some of the rows are collapsing?
I see have some delegates with a null in between like so :
i am seeing this with delegates 1 , 2 and 3 fields.
Be sure that you have Delegate columns only from the left on this join:
@Felipe_Ribeir0i did that? could it be anything else? I have 11 delegate columns in actuality. and my last column is always filled (before your workflow addition). sigh.
@wonka1234 Its possible for you to isolate some rows with all columns showing this problem and share here?
Before your workflow:
Louis.Stevents@hotmail.com
after
