Multiple conditional functions if null

[kmg_16]

Hi,

I have four columns each with bits of data in e.g.

store_id	id	store_number	id_number	final_id
a
	b	b
			c

I would like to create a 'final_id' field where I essentially want to say:

if [store_id] is null, use [id], if [id] is null use [id_number]

([id] and [store_number] are both populated with the same figures so would only need to use one)

Is this possible?

TIA

[binuacs]

@kmg_16 one way of doing this with the help of Transpose tool and Multi-Formula

[danilang · Accepted solution]

Hi @kmg_16 

If you columns don't change, you can use a single formula tool with this expression in it 

if !isnull([store_id]) then
	[store_id]
elseif !isnull([id]) then
	[id]
else
	[id_number]
Endif

You essentially take the first non-null value.

Dan