Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
liamlucas
Contributor II
Contributor II

Prevent Customer from Load in Data Load Script

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
1 Solution

Accepted Solutions
sunny_talwar

Like this

LOAD

    Customer,

    "Sum(Sales)"

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

(ooxml, embedded labels, table is Sales)

Where not Match(Customer, 'Extrawagens') ;

View solution in original post

1 Reply
sunny_talwar

Like this

LOAD

    Customer,

    "Sum(Sales)"

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

(ooxml, embedded labels, table is Sales)

Where not Match(Customer, 'Extrawagens') ;