Conditional Multi-Row

LindonB

Hi All,

Still trying to get a handle on the multi-row formula. I've got a dataframe where I have a column labeling whether there was a second client interaction within one day. I simply am now trying to return the first customer contact ID when a second contact was made. This means that, in the attached WF, I want to group on the name and return the last row's ID sequence whenever a value of 'yes' appears in the Second column. I'm having a bit of trouble with the syntax though. Any help would be greatly appreciated?

Thanks!

Example.yxmd

kgalbert

Hi LSB123,

I think I understand what you're trying to do, but I'm not entirely certain.  In your example would Andrew Jones have no results because he doesn't have any 'Yes' in the [Second] column?

See the attached workflow.  I didn't use the multi-row function.  Instead I filtered for the encounters that had a 'Yes' then used a Summarized tool to get to the earliest date, then joined it back to the original data.

Let me know if this wasn't what you were looking for.  There might be a way to do this with a multi-row filter, but this just seemed easier.

Thanks,
Ken

Example.yxmd