Hi there,
I am trying to use the split node to remove records which appear to be null or blank in one field. In the preview window when I click a cell that looks to have no data in it and select it and click filter it's not picking up the true value in the cell. where as if I filter on an actual value the data appears in the pop up box.
If I try to force it to 'Is Not Null' it doesn't do the split either.
This is the code it generates but it doesn't actually split the records.
Any help would be appreciated on how to split out these records with what appear to have blanks values in them.
Thanks