Prevent Customer from Load in Data Load Script

liamlucas — Thu, 14 Dec 2017 02:30:35 GMT

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);

Customer	Sum(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

Re: Prevent Customer from Load in Data Load Script

sunny_talwar — Thu, 14 Dec 2017 17:03:49 GMT

Like this

LOAD

Customer,

"Sum(Sales)"

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

(ooxml, embedded labels, table is Sales)

Where not Match(Customer, 'Extrawagens') ;

topic Prevent Customer from Load in Data Load Script in App Development

Prevent Customer from Load in Data Load Script

Re: Prevent Customer from Load in Data Load Script