if null copy data from another column

[Qlikuser09]

Company	Company Name
apple
Google
Facebook
	Facebook
	Apple
	Apple
Nil	Nil
apple
	Google

I have a table like this i want to integrate this as a single column called "Company" during Data load

Company

apple

Google

Facebook

Facebook

Apple

Apple

Nil

apple

Google

[Or]

Coalesce(Company,[Company Name]) as Company_New

[Qlikuser09]

i get the values only from Company, and not from the company name (Compnay_New is just the replica of Company)

[Or · Accepted solution]

Check that:

1) The values are actually null, rather than a blank string. If they're a blank string, you can use if(Len(Company)=0,[Company Name],Company)

2) These are the actual values in your data source, that is - you are actually getting rows in your data source where one field is null (or blank) and the other has values.