showing null values in a lookup table

[rdevine]

I have lines in multiple lookup tables that look like

lista,listb,listc,listd
a1,,c1,d1
,,b2,c2,d2
a3,b3,c3,d3

when i do a lookup on these and try to show all of the results it just eats up the lines in the table so i see

a1,b2,c1,d1
a3,b3,c2,d2
empty,empty,c3,d3

is there a way to configure lookup tables to populate a value even if there is nothing there?

[gvhees]

Hi,

Yes, you can use the "fillnull"command like:

|| fillnull value="empty"

the output should now show:
a1,empty,c1,d1
empty,b2,c2,d2
a3,b3,c3,d3

Hope it helps.