Is Multi-Formula the effective tool to solve this issue?

tessaenns

Hello,

I have imported a data set that looks like this:

Sample Delete.JPG

I need it to look like this:

Sample Delete 2.JPG

This is how my workflow looks right now:

Sample 3.JPG

Does anyone have a better solution to offer that is less "messy" and time consuming? I tried the multi-row formula, but could not get the expression to do what I wanted it to.

Thank you!

Best Practices

Accepted answers

CharlieS

@tessaenns

If you rely on the weight field being empty when the assignment is mentioned in the Carrier field, then this will work:

IF isnull([Weight]) THEN [Carrier]
ELSE [Row-1:Assignment] ENDIF

Solution attached.

20180626-CarrierAssignment.yxmd

MarqueeCrew

Hey @tessaenns!

A slightly different approach to this might be to know the domain values that work and not rely on a NULL field. @CharlieS's solution is A1, but you might also like:

IF 
	UpperCase([Carrier]) IN ("ALLOCATED","PROJECTED","EXECUTED") THEN [Carrier]
ELSE 
	[Row-1:Assignment] 
ENDIF

You can update the IN clause with additional status values if there are more. This is a safety net that you only use approved assignments.

Cheers,

Mark

All comments

Claje

Hi,

Any chance you can send over a copy of the screenshot of data either in an Alteryx workflow or in a csv or excel file?

I think I have some recommendations that will be helpful, but having some data to work with will let me prove them out more effectively.

CharlieS

@tessaenns

If you rely on the weight field being empty when the assignment is mentioned in the Carrier field, then this will work:

IF isnull([Weight]) THEN [Carrier]
ELSE [Row-1:Assignment] ENDIF

Solution attached.

20180626-CarrierAssignment.yxmd

tessaenns

Thank you @CharlieS! That worked!

MarqueeCrew

Hey @tessaenns!

A slightly different approach to this might be to know the domain values that work and not rely on a NULL field. @CharlieS's solution is A1, but you might also like:

IF 
	UpperCase([Carrier]) IN ("ALLOCATED","PROJECTED","EXECUTED") THEN [Carrier]
ELSE 
	[Row-1:Assignment] 
ENDIF

You can update the IN clause with additional status values if there are more. This is a safety net that you only use approved assignments.

Cheers,

Mark

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703