Multi If Formula

[NadiaFS]

Hi Community

I am trying to pull data from 2 different sources when my main source is empty.

E.g. I have 1 column called 'Name of exposure' when this column is Empty I want to pull from 'Parent Company Name' however if this Row is also empty I want to pull from 'Issuer name' . There shouldn't be any instance where all 3 are empty. 

Note: I only want to pull data from other columns when my 'Name of exposure' column is empty. 

See my code below in the formula tool that turns everything in 'Name of exposure' from mostly populated to blank. 

IF
!IsEmpty([Name of Exposure]) THEN [Parent Company Name]
ELSEIF !IsEmpty([Parent Company Name]) THEN [Issuer Name]
ELSE [Name of Exposure]
ENDIF

Note 2: I have checked the community solutions, especially this one below, but it doesn't seem to work for my dataset. 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multiple-IsEmpty-Statements/td...

Any help would be much appreciated!

[Bren_Spill · Accepted solution]

Hi,

Try this:

IF
!IsEmpty([Name of Exposure]) then [Name of exposure]
elseif IsEmpty([Name of Exposure]) and !IsEmpty([Parent Company Name]) then [Parent Company Name]
ELSEIF IsEmpty([Parent Company Name]) and !IsEmpty([Issuer name]) THEN [Issuer Name]
ELSE [Name of Exposure]
ENDIF 

[Qiu · Accepted solution]

@NadiaFS 
A slightly simple one.

[grazitti_sapna]

Hi@NadiaFS 

I have made Workflow for your Problem. Please Check.

If it works Kindly accept it as Solution.

Thanks

[NadiaFS]

Thank you, both this and @Bren_Spill 's solution worked!