Check continuous Months in Row Value

[divyakavishwar]

Hi Team,

I have a use case where I need to identify the records which doesn't have continuous month's.

For Example,

 Input data

name	value	Month
1	red1	Jan
1	red1	Feb
2	red2	Jan
2	red2	Mar
2	red2	Apr

output data

name	value	Month
2	red2	Jan
2	red2	Mar
2	red2	Apr

Can anyone help please 

[JosephSerpis]

Hi @divyakavishwar I mocked up a workflow let me know what you think?

[grossal · Accepted solution]

Hi @divyakavishwar,

you could do this using a combination of Sort and Multi-Row-Formulas:

What happens:

- I created a table with Month and Month numbers to make it easier: 

- We join both together and sort it

- Multi-Row-Formula to find the bad ones

- Sort them and another Multi-Row-Formula to mark all bad if one is bad

- Filter only the bad ones

- Sort to get the original order

Result:

Workflow attached. Let me know what you think.

Best

Alex

[neilgallen · Accepted solution]

different approach, using fewer tools. That said, this will not work if your data ever crosses years (i.e. the records contain more than one year and go from December to January). In that case you'd need a year field in order to account for the difference.

[divyakavishwar]

Hi @neilgallen,

Thanks for the solution, Solution provided worked perfectly. 🙂

Regards

[divyakavishwar]

Thank you @grossal