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.
@wonka1234
Try this version
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?
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
Another thing, the tile tool was with a config that possibly could cause issues with more data. try to change it to be like this:
