Forum Discussion
Solved
Find similar pattern
Hi ALL,
| Narrative | Credit | Post date | ||
| TANZANIA LIMITED | 580.00 | 12/14/2020 | ||
| TANZANIA LIMITED | 580.00 | 12/14/2020 | ||
| TANZANIA LIMITED | 580.00 | 12/14/2020 | ||
| TANZANIA LIMITED | 580.00 | 12/14/2020 | ||
| TANZANIA LIMITED | 580.00 | 12/14/2020 | ||
| TANZANIA LIMITED | 580.00 | 12/14/2020 | ||
| EAST AFRICA | 182,248.75 | 12/23/2020 | ||
| MID EAST | 60,000.00 | 3/16/2021 |
I need to identify the pattern above, where In the Narrative column TANZANIA LIMITED is repeating the same Credit value (ie. 580.00) in my data. if the credit value is repeating more than or equal to 5 times by the same narrative then it should identify as a pattern and flag it as TRUE.
Please help resolve this issue.
Thank you.
MintuBaruah , A new column like
var _count = countx(filter(Table, [Narrative] =earlier([Narrative]) && [Credi] = earlier([Credi])), [Credi])
return
if(_count+0 >=5, True(), false())
1 Reply
MintuBaruah , A new column like
var _count = countx(filter(Table, [Narrative] =earlier([Narrative]) && [Credi] = earlier([Credi])), [Credi])
return
if(_count+0 >=5, True(), false())