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

Excel column

Youtecte
7 - Meteor

hi everyone,

 

I really struggle to replicate those 3 excel columns on Alteryx (see the attached ), can someone please help me with this issue. I tried the multi-row formula but the result it's not the same. see the attached

 

Thanks

Youtecte

5 REPLIES 5
danrh
13 - Pulsar

Try something like this in a Multi-Row Formula tool:

IF IsNull([Row-1:A]) THEN [A] ELSE [Row-1:C] ENDIF - [B]

See the attached.  Hope it helps!

CharlieS
17 - Castor
17 - Castor

The first thing that was necessary was to format the input data in an appropriate numeric field format. Take a look at my attached solution and let me know if you have any questions.

 

 

mborriero
11 - Bolide

Could you please provide some information about how do you create the column?

 

The column B has no calculation and it is not clear to me how to calculate it.

 

THanks,

Matteo.

Philip
12 - Quasar

Hi Youtecte

 

I don't understand the problem. Do you mean you have fields 1 & 2, and need to calculate field 3? What are the actual inputs?

ponraj
13 - Pulsar

Here is the sample workflow for your case.  I created iterative macro to solve your case. 

 

 

 

 

Input 1Input 1Input2.PNGWorkflowWorkflowmacro workflowmacro workflowCapture.PNG

Labels