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

[tessaenns]

Hello,

I have imported a data set that looks like this:

I need it to look like this:

This is how my workflow looks right now:

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!

[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 · Accepted solution]

@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.

[tessaenns]

Thank you @CharlieS! That worked!

[MarqueeCrew · Accepted solution]

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

[tessaenns]

@MarqueeCrewthis is an excellent solution, thank you! 

[MarqueeCrew]

@tessaenns,

I'm here to serve!

cheers,

mark