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.