Potential Bug: Multi - Row Formula

Hi,

I'm running version 11.5.1.31573 Alteryx Designer x64 and I think I may have spotted a bug, not sure if it's been fixed for later versions but I've attached a simple macro that hopefully should highlight the problem with some jpegs showing the output of the workflow.

I ran the macro multiple times repeatedly and it seems the Multi - Row Formula tool is giving me different results every now and then (inducing Null values and strange numbers). I hope you can recreate it and it's not just me going crazy...

Many thanks,

Michael

Data Input.JPG Meta Input.JPG Multi-Row Formula Results1.JPG Multi-Row Formula Results2.JPG Multi-Row Formula Results3.JPG

Multi - Row Macro.yxmc

Preparation

Accepted answers

jrgo

@michael_d,

Possible that there is still a bug, but the reason why you're getting different results is because of a setting you configured in the tool

This option was set to "Set to Values of Closest Valid Row", which is why you were getting some really large/unusual values. Instead, use "0 or Empty". It is also good practice sort your results prior to them going into this tool.

Attached is a modified version of your macro that changes this. I also added another option on there that would simplify your expression by specifying "Group By" fields. This essentially restarts the expression for each distinct value(s) within the grouped field(s) selected.

Hope this helps!

Best,

Jimmy

Multi - Row Macro.yxmc

All comments

JessicaS

Hi @michael_d ,

I've moved this post over to the 'data preparation and blending' section.

I'm not able to replicate the issue you are showing in your screen shots. Can you provide a little more color around the steps you go through to produce the issue?

How consistently can you reproduce it?

Thanks,

jrgo

@michael_d,

Possible that there is still a bug, but the reason why you're getting different results is because of a setting you configured in the tool

Hope this helps!

Best,

Jimmy

Multi - Row Macro.yxmc

michael_d

Hi @jrgo and @JessicaS,

Thanks for your swift replies, my apologies I've been a bit under the weather recently. A few things, I seem to be unable to reproduce the problem now even though on Friday it was occurring once every four or five times I ran the macro, it could rear it's head again sometime in the future. I just thought with those crazy values coming out something must be causing it.

Thanks for your efforts and suggestions @jrgo I completely forgot about the group by option and the 0 or Empty does seem to be a better choice in this case, I'm still not sure how that would explain the crazy values I was getting. I'll still accept your answer as a solution.

@JessicaS what other info would you need?

Thanks,

Michael

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703