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 🙂 

[atcodedog05 · Accepted solution]

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 : )

[Joker_Hazard]

atcodedog05,

thanks for the quick answer! At first I thought about this method, but I will have millions of rows in the original dataset. 

By using this method instead of multi row, is it going to demand much more cumputer processing? I'm a layman when it comes to this knowledge... 

thanks 

[atcodedog05]

Hi @Joker_Hazard 

I dont think it would. It would be similar to multi-row approach.

[Joker_Hazard]

You are awesome!! Thanks my friend

[atcodedog05]

Hi @Joker_Hazard 

Here is multi-row formula approach just in case.

Workflow:

Groupingby customer ID and check whether it has 2 rows with "Credited Account" and "Credited Float Account"

Hope this helps : )

[Emil_Kos · Accepted solution]

Hi @Joker_Hazard,

I have created a multi-row formula for you. Please let us know which solution is working faster as I am very curious. 

[Joker_Hazard]

Both work very well.

Thank you so much for the effort!!! Have a great day/week