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

How to retrieve a cell based on a IF logic formula in excel?

keepcalm
7 - Meteor

Hi there,

 

been trying but to no avail.how do i pick a specific cell from an excel tab if a IF formula logic i used in excel is fulfilled?

 

E.g if type =buy then get cell from buy(1) else sell (1)

Noidtest accountTYPEC_P_BUYbuyC_Y_SELLsell
15268663123BUYKRW66666USD123
25268663234BUYKRW7777USD444
35268663555SELLUSD8888KRW555
45268663666SELLUSD9999KRW666

 

Im working all this logic in excel in another tab based on the excel tab above.

 

Thanks for the help.

4 REPLIES 4
echuong1
Alteryx Alumni (Retired)

You can achieve this through a formula tool. See attached for an example.

 

echuong1_0-1578326496864.png

DiganP
Alteryx Alumni (Retired)

@keepcalm @echuong1 described the easiest method.

 

You can learn more about the conditional statements or formula functions in general here

Digan
Alteryx
keepcalm
7 - Meteor
Noidtest accountTYPEC_P_BUYbuyC_Y_SELLsell
15268663123BUYKRW66666USD123
25268663234BUYKRW7777USD444
35268663555SELLUSD8888KRW555
45268663666SELLUSD9999KRW666

 

 

@DiganP and @euchong1 I would like to get a specific cell e.g buy(1) i.e 66666 if it fulfill the logic.Do note that the table are not fixed which emphasize need to retrieve from a specific cell. Appreciate the help!

RolandSchubert
16 - Nebula
16 - Nebula

Hi @keepcalm ,

 

are you trying to replicate an Excel formula like

= IF(D5='BUY', $F$2, $H$2)  => for all rows, one of two specific values is selected depending on the value in a definied column of this row

(counted columns/rows "Excel-like" starting with "No" as A1)

 

An easy option is to select the values needed (comparable to $F$2 and $G$2), use the "Append Fields" tool to add these values to all rows and use the formula @echuong1 suggested. I've attached a sample workflow.

 

Does this help?

 

Best,

 

Roland

 

 

Labels