I need to add a Data Table with transformations that include a data function to delete empty rows resulting from the transformation

I need help creating a data function that will delete empty rows from a data table being added to current analysis.  I'm  adding a transformed "copy" of an original data table from my current analysis, but just need to transform it (pivot) and add a data function that deletes the rows in which the column "Monthly Net Cash Flow" has empty values.  I made a crack at the script but I'm a newbie to IronPython/R and data functions and would appreciate any help with the script as it's not working and I think it has something to do with value citeria which I want to remove null values (see pics) and how to set up the data function input and output parameters would also be helpful.  Thanks. 

Attachments

AttachmentSize
PDF icon 2016-03-30_14-14-22.pdf74.12 KB
PDF icon 2016-04-04_13-01-35.pdf84.21 KB

(1) Answer

Login