Replace Null values with data from other column

[#1]

How can I replace null values from column A with values From column B?

[marcus_malinow]

how about this in your load script?

If(ISNULL(ColumnA),ColumnB,ColumnA) as ColumnA

Marcus

[#3]

maybe you can suppress the null values so that they are not displyed in the table/chart.

[CELAMBARASAN]

If it is number then use Alt(ColumnA, ColumnB)

otherwise you have to use Marcus Malinow suggestion.

[#5]

I guess Marcus Malinow's solution will do the trick.

[#6]

Sadly it does not work. Its a date. For planning production I have DeliveryDate and ExtendedDeliveryDate. As I need to show how the planned deliveries are performing I need to use ExtendedDeliveryDate if there is one, otherwise I need to use DeliveryDate. I was planning to put data from DeliveryDate into null values of ExtendedDeliveryDate so my charts would be more precise. Any suggestions?

[marcus_malinow]

Are the values actually NULL, or empty strings? What is your data source?

If they are empty then this may work.

If(ISNULL(ColumnA) OR ColumnA = '',ColumnB,ColumnA) as ColumnA