Deleting Rows in Spotfire table

I set up my application to read in individual tables then create a master table by "Insert Rows" from the individual tables.  I am trying to delete rows from the master table.   First, I tried to "Mark Rows", then "Delete Marked Rows".    That worked until I reopened the table.  I understand that if the rows are still on the individual tables, they will come back.  However, I even tried deleting the entire individual tables and when I close and reopen, the rows are still in the  master table, although I can't see the individual tables.

Example is below.  The master table was built by the 3 steps below.    Add Table 1, insert rows from Table 2, insert rows from Table 3.  Then I deleted Table 2 and get this dialogue when I load the application.  Not sure what it means ("data is stored for this source") or how to 'unstore' it.

 

1. Select File > Add Data Tables...
    Source: Data table from current analysis
    Data table: Table1
    Update behavior: Automatic
    Last reload: 8/30/2016 10:33 AM
2. Select Insert > Rows...
    Source: Data table from current analysis
    Data table: The source table no longer exists.
    Update behavior: Automatic (not applicable; data is stored for this source)
    Last reload: 8/25/2016 6:12 PM
    Matching behavior: Manual
    Matched columns:
        MEMBER NAME – MEMBER NAME
        LOCATION – LOCATION
        FILLDATE – FILLDATE
        QTY DSP – QTY DSP
        P1 NAME – P1 NAME
        P1 BIN – P1 BIN
        P1 GROUP – P1 GROUP
        MARGIN – MARGIN
        RXPRICE – RXPRICE
        RXCOST – RXCOST
        DRUG NAME – DRUG NAME
        NDC – NDC
    Ignored columns: (None)

 

2. Select Insert > Rows...
    Source: Data table from current analysis
    Data table:  Table3
    Update behavior: Automatic
    Last reload: 8/30/2016 610:34 AM
    Matching behavior: Manual
    Matched columns:
        MEMBER NAME – MEMBER NAME
        LOCATION – LOCATION
        FILLDATE – FILLDATE
        QTY DSP – QTY DSP
        P1 NAME – P1 NAME
        P1 BIN – P1 BIN
        P1 GROUP – P1 GROUP
        MARGIN – MARGIN
        RXPRICE – RXPRICE
        RXCOST – RXCOST
        DRUG NAME – DRUG NAME
        NDC – NDC
    Ignored columns: (None)
 

(1) Answer

Login