Replacing null with Header

[Chauche]

Hi All,

I am using multi-field formula option to replace null values for multiple column as below

"if Isnull ([_CurrentField_]) then "Missing" else [_CurrentField_] endif"

Can I tweak the above formula to replace with respective "Header" instead with "Missing". Any help is appreciated.

For example, null under "Name" Col is replaced with "Name". Similarly, null under "Address" is replaced with "Address" so on. The data is huge with almost 50k rows.

Name	Address	email	phone
Abc	#3, church road	nmy@gmail.com	null
Xyx	null	pqr@gmail.com	562346352
null	6754, House no. A56	null	262665464

[Chauche · Accepted solution]

Please ignore the request. My bad it was very simple. Below worked

if Isnull ([_CurrentField_]) then ([_CurrentFieldName_]) else [_CurrentField_] endif