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

Alteryx designer Discussions

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

I have a situation where I need to combine rows if the duration is greater than 1

Meteor

I am new to Alteryx and I am trying to solve this issue -

 

The data looks like this 

 start dateend dateduration
2/5/20182/11/20188
2/12/20182/18/20188
2/19/20182/25/20188
2/26/20183/4/20188
3/5/20183/11/20188
3/12/20183/18/20188
3/19/20183/25/20188
3/26/20184/1/20188

 

And I want this to look like 

 start dateend dateduration
2/5/20184/1/20188

 

Accordingly I will have to add other fields to sum up the cost.

Any inputs?

@dkchandana3 I think you can use a multi-row tool to basically flag records that should be grouped together. Then a summarize tool can hopefully be used to get the data you're looking for. Have a look at the v11.0 workflow.

Alteryx Certified Partner
Alteryx Certified Partner

I took this a different way from @patrick_digan's solution, but I think it's important to note that we both started with some date field formatting. My solution used the Tile tool (no surprise) and created a group ID for each group of sequential records with duration>1. 

 

 

 

 

 

Meteor

Thank You!

Highlighted
Meteor

Thank You, I used the same

Labels