10 Replies Latest reply: May 23, 2014 8:20 AM by Jason Rathgeber RSS

    How do I remove NULLs after a LEFT JOIN LOAD so I can select blank fields?

    ivang

      I have a bigtable and a smalltable, with a common key field. The smalltable does not contain records for all records in the bigtable. If I LOAD (main fields) from bigtable then LEFT JOIN LOAD (extra fields) from smalltable, I get NULL values in an extra field where a record did not exist in smalltable. If I try to select blank values in an extra field in a list box, I want to include NULL values and existing blank values. Is there a simple way of doing this?