Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance during the next 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

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

Atom

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.

Highlighted
Alteryx
Alteryx

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

 

echuong1_0-1578326496864.png

Highlighted
Alteryx
Alteryx

@keepcalm @echuong1 described the easiest method.

 

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

Digan
Alteryx
Highlighted
Atom
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!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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