Multi Row Formula issues

Joker_Hazard

Hello guys!! 

I'm having issues with Multirow tool. My goal is actually very simple..

As you can see, I need that desired output. 

Each Customer ID is duplicated and must have a credit and a float credit. The ones that does not have that should have this status as "PENDING FLOAT CREDIT". 

I tried using a Multi Row formula but I did not have success.

Thanks in advance for the help 🙂 

Sample Data.yxmd

atcodedog05

Hi @Joker_Hazard 

You can do something like this.

Workflow:

1. Using summarize tool groupby Customer ID and concat validator.

2. Using check whether the concat contains both credit and credit float validator. If yes then ok else "PENDING FLOAT CREDIT.

3. Join this output to main data on customer ID

Hope this helps : )

Sample Data.yxmd