81060_en-US

liliconcom

Importing data from Excel, remove subtotal lines

When importing from data sources often the source data contains a subtotals by category.  Is there a good way to remove these subtotals after import with a JMP function or some script?  Or is there a way to remove these subtotals during import?  Thank you.

Re: Importing data from Excel, remove subtotal linesAnswer Found here:
https://community.jmp.com/t5/Discussions/How-to-delete-rows-based-upon-a-condition/td-p/52999

Update the code for when :"Product Line" =="Subtotal"