Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

tessaenns
9 - Comet

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!

6 REPLIES 6
Claje
14 - Magnetar

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
17 - Castor
17 - Castor

@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
9 - Comet

Thank you @CharlieS! That worked!

MarqueeCrew
20 - Arcturus
20 - Arcturus

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

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
tessaenns
9 - Comet

 

 

 

@MarqueeCrewthis is an excellent solution, thank you! 

MarqueeCrew
20 - Arcturus
20 - Arcturus

@tessaenns,

 

I'm here to serve!

 

cheers,

 

mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels