[MultiRow Tool] How to detect wrong arrays in columns?

Hello Everyone..

I have a doubt about the multirow formula tool. Regarding this image..

I am trying to create a formula that validates if the array contains the same number, three times in a row. If the array contains only one or two rows, then it needs to report which banking account has issues.

I already was able to determine a few parameters for the creation of this array, but I have no clue on how to create this next step.

Maybe using another tool?

Thanks everyone!

Alteryx Workflow.yxmd

Template01.xlsx

Input

Accepted answers

clmc9601

Hi @Joker_Hazard,

Does this accomplish your goal?

Screen Shot 2021-03-05 at 10.17.20 PM.png

Hope it helps!

Alteryx Workflow Joker_Hazard.yxmd

All comments

Emil_Kos

Hi @Joker_Hazard,

Can you share what is the expected output?

Joker_Hazard

Emil,

To give you the context...

Lets talk about transactions. All transactions that enter in the system (Example: Book transfer) after being received, it MUST be blocked (represented by "BALANCE BLOCKED") and afterwards it needs to be unblocked (represented by "BALANCE UNBLOCKED").

What I did was to create an array with those three steps Book transfer receivable -> Blocking -> Unblocking.

However, there are a few drawbacks in the system and sometimes a transaction is not blocked therefore, not unblocked. So what I need is a workflow that detects this lack of "blocking and unblocking" and reports in a browse tool for example which transactions did not get blocked/unblocked.

For this reason that I created this extra column called "Novo Campo" with the arrays

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280