I am extracting some data from the database.
Theses are four fields i.e. value field1,value field2,value field3,value field4 and the fifth field just carries the unit.
I want that if the value fields are blank it should not report anything. In this case it reports a unit.
And if the value field has a value it should report the value as well as the unit.
How to do it?
value field1||'~'||unit field ||','||
value field2 ||'~'||unit field ||','||
value field3 ||'~'||unit field ||','||
value field4 ||'~'||unit field ||','||