3 Replies Latest reply: May 15, 2014 10:03 AM by jodie _ RSS

    need help setting up model

    jodie _

      i am trying to select from this report all item numbers that have no * in front of it and then on those records the invoices, dates, and sales quanity.  everytime i set up my model i get with it the invoices associated with items that also have the * in front of it.  i have pasted an example below.                                                                               

      *1hd                                                                               

      1347640-0003-0003      12/20/05   4000  EA       1.0000         0.0000         1.00          0.00     0.00                                                                               

      *1LE 092.81185                                                                               

      1305507-0001-0001      07/06/04   4800  EA       1.0000        18.0000         2.00         36.00    10.00                                                                               

      *1LE B1030PR                                                                               

      1348528-0001-0001      12/22/05   4800  EA       1.0000         6.0000         6.00         36.00    10.00                                                                               

      *1LE B922HD6                                                                               

      1161902-0001-0001      11/10/99   6200  EA       1.0000     1,485.0000         1.00      1,485.00    20.00                                                                               

      *1LE B930RP2                                                                               

      1348528-0001-0002      12/22/05   4800  EA       1.0000         3.0000         6.00         18.00    10.00                                                                               

      *1LE S610RG                                                                               

      1348528-0001-0003      12/22/05   4800  EA       1.0000       110.0000         1.00        110.00    10.00                                                                               

      ALN 58001                                                                               

      1324264-0001-0006      02/15/05   1200  PK       1.0000         0.1500         4.00          0.60    33.33                                                                               

      ALN 58002                                                                               

      1344624-0003-0005      11/04/05   1200  PK       1.0000         0.1700         4.00          0.68    36.76    

                            1353486-0001-0004      02/16/06   1200  PK       1.0000         0.1700         4.00          0.68    36.76                                                                               

      ALN 58006                                                                               

      1327596-0001-0005      03/24/05   1200  PK       1.0000         0.2200         3.00          0.66    42.41    

                            1327596-0004-0005      04/12/05   1200  PK       1.0000         0.2200         3.00          0.66    36.36                                                                               

      ALN 58012                                                                               

      1339884-0001-0002      08/29/05   1200  PK       1.0000         0.2700         6.00          1.62    40.74                                                                               

      ALN 58014                                                                               

      1330443-0001-0004      04/27/05   1200  PK       1.0000         0.3400         6.00          2.04    41.18    

                            1338192-0001-0003      08/08/05   1200  PK       1.0000         0.3400         6.00          2.04    35.29

        • need help setting up model
          Nick Osdale-Popa

          When you do the trap, are you including the field with the asterisk and is the asterisk in the field itself?

           

          If so, in your table just filter out the rows that have the asterisk.

          • need help setting up model
            Data Kruncher

            Hi Jodie,

             

            Rather than struggling to avoid including those records in your extraction, I'd be more inclined to extract everything and then just filter those items out of the data set.

             

            Create a new filter with this expression:

            [SIZE=2]/* Asc("*") = 42 */[/SIZE]

            [SIZE=2]Asc(Left(Item,1)) <> 42[/SIZE][/SIZE][/code]

             

            Your table will then only show the ALN records.

             

            Edit: beat to it by Nick.

             

            HTH,

            Kruncher

              • need help setting up model
                jodie _

                i am trapping only items without the asterisk however when i go to trap the invoices numbers below the items without the asterisk i am also getting invoice numbers tied to all items, even those with the asterisk and those i do not want.