Copy the field if value is Null

[prabunakil]

how to write script if the childmaterial field is null, copy the material value to the child material value.

but if child material value field have items, then no need to do anythings.

[qlikviewwizard]

Your requirement is not clear.

Can you explain in details with the example,please?

[prabunakil]

Hi Arjun

This table is combine with two SQL,

1st SQL table include of Material , Description

2nd SQL Table include of Material, ChildMaterial, ChildDescription.

Both SQL is link by Material

so if my child material , exist, my field will show child material, but if child material is empty, i would like to copy the material to the child material field.

[tharanikannan]

Hi

Use somethimg like this,

if (isnull(ChildMaterial),Material, ChildMaterial) as MaterialID

in your table.

Thanks,

Tharani.

[prabunakil]

It did not work