community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Conditional Multi-Row

Highlighted
Meteor

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!

Asteroid

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

Meteor

Hi khalbert,

 

Yes, exactly. This is certainly helpful! Unfortunately, filtering doesn't exactly work as if there is a meeting followed by a meeting the next day followed by a meeting the next day the second makes the third a repeat as well, as is the case with John Smith.

 

Here's how I ended up solving it. I added a multi row formula grouped on the name to take the ID - 1. I added no condition and didn't filter before hand. That basically added a column for the row prior's ID. Then I filered to only have the second interaction equal yes.

 

Thanks again!!!

Labels