0 Replies Latest reply: Apr 23, 2010 11:06 AM by jimy RSS

    Using snapshot "facts" with daily facts

    jimy

      I'm still somewhat new to Qlikview, and for the most part have been able to provide answers for the analysts using the package. But I now have a request that has me stumped.

      Some background. The product being sold is clothing. The lowest level (e.g. UPC or SKU) is the style/color/size. Some reports roll the sizes into just the style/color, others roll up to just the style level. At that level a style has a description, belongs to a group, can be assigned to several different status groups, etc.

      The fact table in this case is the shipments, recorded daily at the style/color/size level. The report I'm trying to create is at the style level. It is to show the weekly total shipment units for each of the last six weeks, the grand total shipments, and then a column with the available for sale (AFS) quantity. There is an AFS value for each style/color/size, and the values are updated every morning. I can do this in SQL.

      An example of that output (sorry about the spacing, I couldn't figure out how to get this as a monospaced font):

      GROUP STS STYLE DESCRIPTION WEEK6 WEEK5 WEEK4 WEEK3 WEEK2 WEEK1 TOTAL AFS
      BUBBLE MESH N STYLE620 PANTY BUBL MSH 0 0 138 15 18 29 200 3
      BUBBLE MESH P STYLE620 PANTY BUBL MSH 14 6 7 17 9 5 58 656
      STRETCH MESH A STYLE150 PANTY STR MESH 95 95 101 34 75 65 465 3,268

      But I can't get the same result in QV. Part of the problem is dealing with the AFS. Is that a fact table?. Or are the AFS quantities attibutes of the items. I have tried joining the AFS table to the product master, thinking then that I could do something like just sum the AFS quantities. All I got from that was the error in calculation message. I also tried adding a date field to the AFS table, with the date being set to the current date, and then concatenating the AFS table to the shipment facts table. But that created an AFS column, populated with nulls, for each of the past 6 weeks. I've also tried various aggregation functions, again with no luck.

      I used the sample data to create a list box of calendar week ending dates, CALNDRWKEND, and a chart table (fast change types Pivot and Straight) with dimensions of GROUPNAME, SIZESTSCD, BASESTYLE, STYLEDESC1 and CALNDRWKEND. There is one expression SHIP UNITS, which is SUM(QTYSHIPPED). Partial sums are calculated for CALNDRWKEND. The above sample was for weeks ending 2010-03-06 through 2010-04-10.

      At this point I don't know what to try next, and would welcome any suggestions. We are running version 9.00.7320.7 SR2

      Oh, one other complication. The table is to show all styles with a non-zero AFS quantity, even if there were no shipments in the period selected.

      After copying in all the code I realized that I could attach a document. So if I am doing this properly my test document will also be included.

       


      Calendar:
      Load * inline
      [CALENDARID, CALNDRDATE, CALNDRWKEND
      1885, '2010-02-28', '2010-03-06'
      1886, '2010-03-01', '2010-03-06'
      1887, '2010-03-02', '2010-03-06'
      1888, '2010-03-03', '2010-03-06'
      1889, '2010-03-04', '2010-03-06'
      1890, '2010-03-05', '2010-03-06'
      1891, '2010-03-06', '2010-03-06'
      1892, '2010-03-07', '2010-03-13'
      1893, '2010-03-08', '2010-03-13'
      1894, '2010-03-09', '2010-03-13'
      1895, '2010-03-10', '2010-03-13'
      1896, '2010-03-11', '2010-03-13'
      1897, '2010-03-12', '2010-03-13'
      1898, '2010-03-13', '2010-03-13'
      1899, '2010-03-14', '2010-03-20'
      1900, '2010-03-15', '2010-03-20'
      1901, '2010-03-16', '2010-03-20'
      1902, '2010-03-17', '2010-03-20'
      1903, '2010-03-18', '2010-03-20'
      1904, '2010-03-19', '2010-03-20'
      1905, '2010-03-20', '2010-03-20'
      1906, '2010-03-21', '2010-03-27'
      1907, '2010-03-22', '2010-03-27'
      1908, '2010-03-23', '2010-03-27'
      1909, '2010-03-24', '2010-03-27'
      1910, '2010-03-25', '2010-03-27'
      1911, '2010-03-26', '2010-03-27'
      1912, '2010-03-27', '2010-03-27'
      1913, '2010-03-28', '2010-04-03'
      1914, '2010-03-29', '2010-04-03'
      1915, '2010-03-30', '2010-04-03'
      1916, '2010-03-31', '2010-04-03'
      1917, '2010-04-01', '2010-04-03'
      1918, '2010-04-02', '2010-04-03'
      1919, '2010-04-03', '2010-04-03'
      1920, '2010-04-04', '2010-04-10'
      1921, '2010-04-05', '2010-04-10'
      1922, '2010-04-06', '2010-04-10'
      1923, '2010-04-07', '2010-04-10'
      1924, '2010-04-08', '2010-04-10'
      1925, '2010-04-09', '2010-04-10'
      1926, '2010-04-10', '2010-04-10'
      1927, '2010-04-11', '2010-04-17'
      1928, '2010-04-12', '2010-04-17'
      1929, '2010-04-13', '2010-04-17'
      1930, '2010-04-14', '2010-04-17'
      1931, '2010-04-15', '2010-04-17'
      1932, '2010-04-16', '2010-04-17'
      1933, '2010-04-17', '2010-04-17'
      ];

      Shpfacts:
      Load * inline
      [CALENDARID, PRODUCTID, QTYSHIPPED, GROSSAMOUNT
      1886, 117982, 6, 45.60
      1886, 205113, 2, 20.42
      1886, 117956, 6, 45.60
      1886, 117995, 6, 45.60
      1886, 118003, 6, 45.60
      1886, 205114, 3, 30.63
      1886, 205112, 3, 30.63
      1886, 117990, 6, 45.60
      1886, 117964, 6, 45.60
      1887, 118003, 1, 7.60
      1888, 117990, 22, 176.00
      1888, 117956, 4, 32.00
      1888, 150093, 3, 32.25
      1888, 118003, 8, 64.00
      1888, 150097, 1, 10.75
      1888, 117995, 4, 32.00
      1888, 117982, 6, 48.00
      1888, 117964, 4, 32.00
      1888, 150089, 2, 21.50
      1890, 118003, 2, 16.00
      1890, 117995, 2, 16.00
      1890, 117982, 1, 8.00
      1890, 117964, 4, 32.00
      1890, 117956, 1, 8.00
      1893, 150093, 2, 15.06
      1893, 150097, 2, 15.06
      1893, 150089, 1, 7.53
      1894, 117956, 2, 15.20
      1894, 117964, 2, 15.20
      1894, 117990, 10, 76.00
      1894, 118003, 17, 131.60
      1894, 117995, 1, 7.60
      1895, 150089, 1, 10.21
      1895, 117995, 1, 7.60
      1895, 117956, 1, 7.60
      1895, 118003, 3, 23.20
      1895, 117964, 1, 7.60
      1895, 117990, 3, 23.20
      1896, 117964, 2, 16.00
      1896, 117982, 6, 40.02
      1896, 117977, 3, 24.00
      1896, 117995, 2, 16.00
      1896, 118003, 7, 56.00
      1896, 117956, 1, 8.00
      1896, 117990, 10, 80.00
      1897, 117964, 5, 40.00
      1897, 117982, 2, 16.00
      1897, 117956, 5, 40.00
      1897, 117990, 6, 48.00
      1897, 117995, 2, 16.00
      1897, 118003, 3, 22.40
      1901, 117982, 1, 8.00
      1901, 118003, 1, 8.00
      1901, 150097, 2, 21.50
      1901, 216556, 1, 10.75
      1901, 216554, 1, 10.75
      1901, 150093, 1, 10.75
      1901, 117990, 1, 8.00
      1901, 150089, 2, 21.50
      1901, 216555, 1, 10.75
      1902, 205063, 2, 16.00
      1902, 216556, 5, 53.75
      1902, 150093, 2, 20.42
      1902, 205065, 14, 112.00
      1902, 117982, 7, 54.00
      1902, 216555, 3, 32.25
      1902, 117995, 5, 38.80
      1902, 117964, 5, 38.40
      1902, 118003, 6, 46.40
      1902, 216554, 5, 53.75
      1902, 117990, 7, 54.00
      1902, 117956, 4, 30.80
      1903, 117982, 7, 56.00
      1903, 216556, 5, 53.75
      1903, 118003, 6, 48.00
      1903, 117990, 7, 56.00
      1903, 117969, 2, 16.00
      1903, 117995, 7, 56.00
      1903, 117956, 7, 56.00
      1903, 216554, 5, 53.75
      1903, 117964, 5, 40.00
      1903, 216555, 3, 32.25
      1904, 117956, 1, 8.00
      1904, 117995, 3, 24.00
      1904, 216556, 52, 559.00
      1904, 216555, 27, 290.25
      1904, 117990, 2, 16.00
      1904, 118003, 1, 8.00
      1904, 216554, 30, 322.50
      1907, 216555, 1, 10.75
      1907, 216554, 1, 10.75
      1907, 216556, 2, 21.50
      1908, 117969, 6, 48.00
      1908, 117956, 3, 22.80
      1908, 117982, 2, 12.96
      1908, 117964, 2, 15.20
      1908, 117995, 1, 7.60
      1908, 117977, 6, 48.00
      1908, 150093, 2, 21.80
      1908, 117990, 7, 53.20
      1908, 150097, 1, 10.90
      1908, 118003, 7, 53.60
      1909, 216556, 5, 53.75
      1909, 216554, 3, 32.25
      1909, 216555, 3, 32.25
      1910, 150093, 2, 21.50
      1911, 150099, 1, 10.75
      1911, 150097, 4, 43.00
      1911, 150093, 4, 43.00
      1911, 150089, 3, 32.25
      1915, 117964, 13, 95.20
      1915, 150097, 1, 10.75
      1915, 216556, 1, 10.75
      1915, 150089, 1, 10.75
      1915, 117956, 5, 40.00
      1915, 117982, 15, 120.00
      1915, 117990, 13, 100.00
      1915, 118003, 6, 48.00
      1915, 117995, 13, 104.00
      1915, 150093, 1, 10.75
      1916, 117982, 1, 7.60
      1916, 150097, 2, 20.42
      1916, 117990, 1, 7.60
      1916, 216554, 2, 21.50
      1916, 117995, 1, 7.60
      1916, 216556, 1, 10.75
      1916, 150089, 1, 10.21
      1917, 117982, 1, 8.00
      1917, 117964, 2, 16.00
      1917, 216556, 6, 61.26
      1917, 117995, 2, 16.00
      1917, 117990, 2, 16.00
      1917, 150093, 3, 32.25
      1917, 216555, 4, 40.84
      1917, 216554, 4, 40.84
      1921, 117995, 2, 15.20
      1921, 117990, 2, 16.00
      1922, 216556, 2, 21.50
      1922, 216554, 11, 118.25
      1924, 118003, 7, 56.00
      1924, 216556, 1, 10.75
      1924, 117964, 3, 24.00
      1924, 117995, 6, 48.00
      1924, 117956, 4, 32.00
      1924, 117990, 7, 56.00
      1924, 117977, 2, 16.00
      1924, 117982, 7, 56.00
      1925, 118003, 3, 22.80
      1925, 216556, 6, 64.50
      1925, 150093, 5, 54.50
      1925, 216555, 4, 43.00
      1925, 117990, 8, 60.80
      1925, 117956, 5, 38.80
      1925, 117964, 6, 45.60
      1925, 117982, 2, 15.60
      1925, 117995, 1, 8.00
      1925, 216554, 5, 53.75
      ];

      Products:
      Load * inline
      [PRODUCTID, GROUPNAME, SIZESTSCD, BASESTYLE, STYLEDESC1, NRFCOLORNAME, NRFCOLOR, SIZE
      47552, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, XS
      47553, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTBK, 002, XS
      47554, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, XS
      47555, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, XS
      47556, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, XS
      47557, STRETCH MESH, A,STYLE150, PANTY STR MESH, GRNFL, 304, XS
      47558, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, XS
      47559, STRETCH MESH, A,STYLE150, PANTY STR MESH, PNKFL, 660, XS
      47560, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTCA, 811, XS
      47561, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, XS
      47562, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, S
      47563, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, S
      47564, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKRR, 004, S
      47565, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKDT, 008, S
      47566, STRETCH MESH, A,STYLE150, PANTY STR MESH, SNOGG, 103, S
      47567, STRETCH MESH, A,STYLE150, PANTY STR MESH, GRNFL, 304, S
      47568, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, S
      47569, STRETCH MESH, A,STYLE150, PANTY STR MESH, PNKFL, 660, S
      47570, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, S
      47571, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, S
      47572, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, M
      47573, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, M
      47574, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKRR, 004, M
      47575, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKDT, 008, M
      47576, STRETCH MESH, A,STYLE150, PANTY STR MESH, SNOGG, 103, M
      47577, STRETCH MESH, A,STYLE150, PANTY STR MESH, GRNFL, 304, M
      47578, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, M
      47579, STRETCH MESH, A,STYLE150, PANTY STR MESH, PNKFL, 660, M
      47580, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, M
      47581, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, M
      47582, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, L
      47583, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, L
      47584, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKRR, 004, L
      47585, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKDT, 008, L
      47586, STRETCH MESH, A,STYLE150, PANTY STR MESH, SNOGG, 103, L
      47587, STRETCH MESH, A,STYLE150, PANTY STR MESH, GRNFL, 304, L
      47588, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, L
      47589, STRETCH MESH, A,STYLE150, PANTY STR MESH, PNKFL, 660, L
      47590, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, L
      47591, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, L
      117952, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKGH, 001, L
      117953, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, L
      117954, STRETCH MESH, A,STYLE150, PANTY STR MESH, FLPBL, 003, L
      117955, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, L
      117956, STRETCH MESH, A,STYLE150, PANTY STR MESH, BKDOT, 007, L
      117957, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, L
      117958, STRETCH MESH, A,STYLE150, PANTY STR MESH, BBBLK, 009, L
      117959, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, L
      117960, STRETCH MESH, N,STYLE150, PANTY STR MESH, GRNFL, 304, L
      117961, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLSHD, 451, L
      117962, STRETCH MESH, N,STYLE150, PANTY STR MESH, PNKFL, 660, L
      117963, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, L
      117964, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, L
      117965, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, XS
      117966, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTBK, 002, XS
      117967, STRETCH MESH, A,STYLE150, PANTY STR MESH, FLPBL, 003, XS
      117968, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, XS
      117969, STRETCH MESH, A,STYLE150, PANTY STR MESH, BKDOT, 007, XS
      117970, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, XS
      117971, STRETCH MESH, A,STYLE150, PANTY STR MESH, BBBLK, 009, XS
      117972, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, XS
      117973, STRETCH MESH, N,STYLE150, PANTY STR MESH, GRNFL, 304, XS
      117974, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, XS
      117975, STRETCH MESH, N,STYLE150, PANTY STR MESH, PNKFL, 660, XS
      117976, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTCA, 811, XS
      117977, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, XS
      117978, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKGH, 001, M
      117979, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, M
      117980, STRETCH MESH, A,STYLE150, PANTY STR MESH, FLPBL, 003, M
      117981, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, M
      117982, STRETCH MESH, A,STYLE150, PANTY STR MESH, BKDOT, 007, M
      117983, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, M
      117984, STRETCH MESH, A,STYLE150, PANTY STR MESH, BBBLK, 009, M
      117985, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, M
      117986, STRETCH MESH, N,STYLE150, PANTY STR MESH, GRNFL, 304, M
      117987, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLSHD, 451, M
      117988, STRETCH MESH, N,STYLE150, PANTY STR MESH, PNKFL, 660, M
      117989, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, M
      117990, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, M
      117991, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKGH, 001, S
      117992, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, S
      117993, STRETCH MESH, A,STYLE150, PANTY STR MESH, FLPBL, 003, S
      117994, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, S
      117995, STRETCH MESH, A,STYLE150, PANTY STR MESH, BKDOT, 007, S
      117996, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, S
      117997, STRETCH MESH, A,STYLE150, PANTY STR MESH, BBBLK, 009, S
      117998, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, S
      117999, STRETCH MESH, N,STYLE150, PANTY STR MESH, GRNFL, 304, S
      118000, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLSHD, 451, S
      118001, STRETCH MESH, N,STYLE150, PANTY STR MESH, PNKFL, 660, S
      118002, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, S
      118003, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, S
      138485, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, L
      138486, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, L
      138487, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, M
      138488, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, M
      138489, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, S
      138490, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, S
      138491, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTBK, 002, XS
      138492, STRETCH MESH, N,STYLE150, PANTY STR MESH, BCHNT, 966, XS
      150089, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BLACK, 001, L
      150090, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, DALIA, 429, L
      150091, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, LROSE, 654, L
      150092, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BBGUM, 663, L
      150093, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BLACK, 001, M
      150094, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, DALIA, 429, M
      150095, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, LROSE, 654, M
      150096, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BBGUM, 663, M
      150097, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BLACK, 001, S
      150098, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, DALIA, 429, S
      150099, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, LROSE, 654, S
      150100, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BBGUM, 663, S
      158746, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, S
      158747, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, M
      158748, STRETCH MESH, N,STYLE150, PANTY STR MESH, BCHNT, 966, XS
      158749, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, L
      192995, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKBH, 005, XS
      192996, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, M
      192997, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, L
      192998, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, S
      205063, STRETCH MESH, A,STYLE150, PANTY STR MESH, PPROS, 662, M
      205064, STRETCH MESH, A,STYLE150, PANTY STR MESH, PPROS, 662, L
      205065, STRETCH MESH, A,STYLE150, PANTY STR MESH, PPROS, 662, S
      205066, STRETCH MESH, N,STYLE150, PANTY STR MESH, PPROS, 662, XS
      205112, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, POOLP, 440, S
      205113, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, POOLP, 440, L
      205114, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, POOLP, 440, M
      212333, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, L
      212334, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, S
      212335, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, M
      212336, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKBH, 005, XS
      214399, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, DALIA, 429, M
      214400, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, BBGUM, 663, M
      214401, BUBBLE MESH , A,STYLE620, PANTY BUBL MSH, DALIA, 429, S
      214402, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, BBGUM, 663, S
      214403, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, DALIA, 429, L
      214404, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, BBGUM, 663, L
      216489, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLUBB, 466, XS
      216490, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLUBB, 466, S
      216491, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLUBB, 466, M
      216492, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLUBB, 466, L
      216554, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CNTLP, 810, S
      216555, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CNTLP, 810, L
      216556, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CNTLP, 810, M
      230399, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKFF, 010, XS
      230400, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKFF, 010, S
      230401, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKFF, 010, M
      230402, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKFF, 010, L
      244851, STRETCH MESH, N,STYLE150, PANTY STR MESH, BOBLK, 011, M
      244852, STRETCH MESH, N,STYLE150, PANTY STR MESH, BOBLK, 011, S
      244853, STRETCH MESH, N,STYLE150, PANTY STR MESH, BOBLK, 011, XS
      244854, STRETCH MESH, N,STYLE150, PANTY STR MESH, BOBLK, 011, L
      244910, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CHINA, 271, M
      244911, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, REDRJ, 617, M
      244912, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CHINA, 271, S
      244913, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, REDRJ, 617, S
      244914, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CHINA, 271, L
      244915, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, REDRJ, 617, L
      ];

      AFS:
      Load * inline
      [PRODUCTID, AFS
      47557, 0
      47559, 0
      47560, 0
      47561, 0
      47563, 0
      47564, 0
      47565, 0
      47566, 0
      47567, 0
      47569, 0
      47570, 0
      47571, 0
      47573, 0
      47574, 0
      47575, 0
      47576, 0
      47577, 0
      47579, 0
      47580, 0
      47581, 0
      47583, 0
      47584, 0
      47585, 0
      47586, 0
      47587, 0
      47589, 0
      47590, 0
      47591, 0
      117952, -4
      117953, 0
      117954, 0
      117956, 322
      117958, 0
      117961, 0
      117963, 0
      117964, 449
      117965, 0
      117967, 0
      117969, 101
      117971, 0
      117974, 0
      117977, 127
      117978, -8
      117979, 0
      117980, 0
      117982, 512
      117984, 0
      117987, 0
      117989, 0
      117990, 679
      117991, -8
      117992, 0
      117993, 0
      117995, 442
      117997, 0
      118000, 0
      118002, 0
      118003, 678
      138485, 0
      138486, 0
      138487, 0
      138488, 0
      138489, 0
      138490, 0
      158746, 0
      158747, 0
      158749, 0
      192995, 0
      192996, 0
      192997, 0
      192998, 0
      205063, 0
      205064, 0
      205065, 0
      205066, 0
      212333, 0
      212334, 0
      212335, 0
      216489, 0
      216490, 0
      216491, 0
      216492, 0
      230399, -1
      230400, 12
      230401, 8
      230402, 4
      244851, 24
      244852, 24
      244853, -17
      244854, 2
      150089, 161
      150090, 0
      150091, 0
      150092, 0
      150093, 310
      150094, 0
      150095, 0
      150096, 0
      150097, 190
      150098, 0
      150099, 1
      150100, 0
      205112, 0
      205113, 0
      205114, 0
      214401, 0
      216554, 0
      216555, 0
      216556, 6
      244910, 0
      244911, -1
      244912, 0
      244913, -1
      244914, 0
      244915, -1
      ];