[MultiRowFormula] How to create an unique key for using it on MultiRowFormula?

Joker_Hazard

Hello everyone!

I am struggling with trying to use multirow Formula and creating a unique key column to use in this tool.

Here's what I have:

We have an banking account column, a transaction column Called "Historical_description" and an ID column that refers to the number that specifies the transaction.

I need to create a validation process which creates an array (block) with each payment (TED receivable -> Balance Blocking -> Balance Unblocking). Those 3 steps exist FOR ONE payment only that is called "TED Receivable".

I tried to concatenate a few columns to create an unique key that could be used in the multirow tool, but no success... Do you guys have any clue or hints to give me? 

Thanks!

Alteryx Workflow.yxmd

Template01.xlsx

apathetichell

change the multi-row formula to display two rows and then:

if isnull([Row-1:Historical_Description]) then 0 elseif([Historical_Description]="ted receivable" and [Row+1:Historical_Description]="balance blocking" and [Row+2:Historical_Description]="balance unblocking") then [Row-1:ted receivable]+1 else [Row-1:ted receivable] endif