BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
BSwid

Contributor

Joined:

Sep 25, 2018

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
BSwid

Contributor

Joined:

Sep 25, 2018

Solution

Re: Importing data from Excel, remove subtotal lines

Answer 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"
1 REPLY 1
Highlighted
BSwid

Contributor

Joined:

Sep 25, 2018

Solution

Re: Importing data from Excel, remove subtotal lines

Answer 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"