You can try this Approach
Step 1 :
Add data cleaning tool
select remove Null rows
This will remove all Null rows
Step: 2
you need only data which is Active
create new field which is Active
Add formula tool create new column
add this formula :
IF Contains([Field1], "Loans Active")
then 'Active'
elseif contains([Field1], 'Loans Repaid')
then 'repaid'
else ''
endif
Step : 3
Add multi row formula tool, update existing new field
IF ISEMPTY([ACTIVE])
THEN [Row-1:ACTIVE]
ELSE [ACTIVE]
ENDIF
Step : 4
Use Filter
add this formula
[ACTIVE] = "Active" AND
[Field1] IN ('Bank Name', 'HDFC', 'IDFC' ,'SBI')
This approach will make your workflow dynamic
