This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would appreciate some help. may I know the right formula if in excel the formula is the following ( =IF(H2<>"(blank)",H2,IF(F2<>"(blank)",F2,IF(G2<>"(blank)",IF(M2<>"(blank)",M2,"(blank)"),"(blank)"))) what should i use in alteryx?.
I would like to add another solution possibility for your consideration. While it is possible to "convert" the Excel code into an Alteryx formula, I find that the result is somewhat hard to read. @BarnesK provided you with a solution that obviously works. Please take a look at this alternative formula:
!IsEmpty([H]) THEN [H] ELSEIF
!IsEmpty([F]) THEN [F] ELSEIF
!IsEmpty([G]) THEN [G] ELSE
If I had to explain the code to my boss/Mom/child/anyone without an Excel background, I think that this formula would be less time consuming to explain. In fact, you can comment the formula too and make it even easier.
!IsEmpty([H]) THEN [H] ELSEIF //Take data from the first column
!IsEmpty([F]) THEN [F] ELSEIF //Resort to the second column if 1 is empty
!IsEmpty([G]) THEN [G] ELSE //Settle for the third column if 2 is empty
[M] //You're stuck with the 4th column now
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.