1 Reply Latest reply: Dec 14, 2017 12:03 PM by Sunny Talwar RSS

    Prevent Customer from Load in Data Load Script

    Liam Lucas

      I want to block the customer named “Extrawagens” from being loaded in the Data Load Script below.  Can you tell me how to do it?

       

       

      LOAD

          Customer,

          "Sum(Sales)"

      FROM [lib://2017Sales/Sales.xlsx]

      (ooxml, embedded labels, table is Sales);

       

        

      CustomerSum(Sales)
      Grunewald$201,320
      Th Fashing$152,115
      Champes$91,362
      The Corner Store$82,520
      Eintrach GS$75,154
      Don Balón$68,266
      Warp AG$65,816
      Vite$59,977
      Boombastic$50,922
      Roba di Piel$49,783
      Extrawagens$45,274
      Bond Ltd$41,087
      Urras Shop$39,839
      Gluderstedt$36,098
      Noch Einmal GMBH$35,526
      Halle Köln$33,365
      Menàge à Trois$27,641
      El Zapato Rojo$27,576
      Nirvana Stores$22,722
      El Carnevale$22,545
      Design$21,565
      Davenport Fashion$21,133
      Millenium$20,822
      Los Vatos Locos$19,683
      El Pirata$18,636
      Paintho da Gama$15,099
      Casual Clothing$14,510
      Sunny Ski Store$14,331
      Los Trajes de Matador$13,307
      Big Foot Shoes$11,413
      Golden Design Group$11,397
      Fritid AB$10,795
      Cloe do Pau$10,325
      Le Sais de Rión$10,003
      La Boheme$9,455
      Las Corbatas$9,374
      Merced do Vaile$9,211
      Ski Store$9,194
      Art et Fashion$9,081
      Belgium Black Jeans$9,041
      La Ropa Vieja$8,985
      La Moda Pasada$8,786
      Copacabana$8,708
      La Moda d'il Futuri$8,334
      Too Hot 4U$7,907
      La Roba do Santho$7,893
      Macalena$7,308
      Los Espandrilos Fantasticos$6,923
      Dr Jims Trousers$6,688
      Stephanies$6,528
      El Traige do Benfica$6,337
      Perkii Urkii$6,015
      De la Vita$4,912
      Slotzy Danz$3,977
      Autokleider$3,912
      La Legion Mercenaire$3,476
      Da Bikini Expertu$3,171
      X-Site$3,049
      King Size Clothes$2,904
      Man Kleider$2,643
      Shoe Expert$2,574
      El Chandal del Barca$2,568
      Bobby Socks$2,458
      Eye Fashion$2,415
      El Abrigo Mortal$2,364
      Los Pantalones Magicos$2,317
      Sport Shop$2,125
      La Moda Alucinante$1,770
      Il Pantaloni di la Cammorra$1,746
      Fast Sunglasses$1,700
      Aujourd´hui$1,533
      Tendha do Flamengo$1,495
      Das Alpen Shoe$1,458
      La Camisas Cansadas$1,442
      TTT-The Ticky Tie$1,163
      Ropa total$1,113
      La Tienda de la Esquina$1,016
      The sharped dressed man$883
      Chateau de Ville$743
      Pour l´homme$707
      SSS-Sport Shoes Store$553
      Pulp Toxedos$537
      Leningrad Cowboys Shop$443
      Kohl Industries AG$287
      For The Dark Night$264
      Fawtly Towers$237
      Alles Lusekofter$193
      Los Sombreros Gigantes$106
      Da Santho Cosmethia$66