Data360 Analyze

 View Only
  • 1.  Split Node Issue

    Posted 03-13-2019 07:32

    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

     



  • 2.  RE: Split Node Issue

    Posted 03-13-2019 09:19

    The interface gives you a red flag as if you're not allowed to have the value empty but you can actually have the value empty for an empty string and it will work. You might have to put in one white space and then delete it. We have an issue logged over this to make it more user friendly.

     

    Alternatively you could use a Transform node and configure it like my second screenshot.

     

     

    Attached files

    split.png
    transform.png

     



  • 3.  RE: Split Node Issue

    Posted 03-13-2019 10:06

    Thanks so much.  Both worked perfect!

     

    much appreciated.

    Jamie



  • 4.  RE: Split Node Issue

    Employee
    Posted 04-03-2019 04:39


  • 5.  RE: Split Node Issue

    Posted 04-04-2019 06:49

    Thank so much!