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 namevalueMonth1red1Jan1red1Feb2red2Jan2red2Mar2red2Apr output data namevalueMonth2red2Jan2red2Mar2red2Apr Can anyone help please

Check continuous Months in Row Value

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

Workflow

Accepted answers

grossal

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

2020-05-04-identify missing month.yxmd

neilgallen

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.