Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multiple consecutive weeks merge

aroumpelaki
8 - Asteroid

Hello!

 

I have been trying to merge consecutive weeks to one row with the minimum start date and maximum end date.

An example is shown below.

From:

aroumpelaki_0-1664365504034.png

To:

aroumpelaki_1-1664365542813.png

 

I have tried to use the multirow formula, but the problem is that the consecutive week number is indefinitely high.

 

Any thoughts on this? 

 

6 REPLIES 6
messi007
15 - Aurora
15 - Aurora

Hello @aroumpelaki,

 

Could you share a sample data instead of a screen shot?

It will help us to give you the solution.

 

Regards,

Ladarthure
14 - Magnetar
14 - Magnetar

Hi @aroumpelaki,

 

to do this, you can process in 3 steps :

  1. sort your data by date (and eventually other attributes)
  2. use a multi row formula to identify if weeks (or in your case start date from the current row is 1 more day than the end of previous row)
  3. use a summarize to agregate

 

aroumpelaki
8 - Asteroid

You are right, I have uploaded the two tables I have used in the screenshots.

messi007
15 - Aurora
15 - Aurora

@aroumpelaki,

 

Please see below :

 

messi007_0-1664367780856.png

 

Attached the workflow,

Regards

aroumpelaki
8 - Asteroid

Thank you very much! It works like a charm!

 

Once more the solution was so simple!

aroumpelaki
8 - Asteroid

@messi007 this doesn't really do the trick, as I essentially was trying to identify periods of weeks.

@Ladarthure works just fine!

 

Thank you both for your time and suggestions!

Labels