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
Solved! Go to 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