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: 
Anonymous
Not applicable

Exctract rows from excel random

Hello i have a XLS sheet of 1.000 rows. I must extract 5 rows random with almost a city and copy in other xls sheet.

I have tried but i am going crazy.

Please help me. Thank you.

mariostia@hotmail.com

Here there is a xls sample of some rows.

Snap 2016-02-16 at 09.53.37.png

Thanks

3 Replies
sunny_talwar

May be use Sample 5 before the LOAD statement to randomly select 5 rows from your table.

Table:

SAMPLE 5

LOAD [Account Code],

          City,

          ...

FROM Source;

ecolomer
Master II
Master II

You can use SAMPLE sentence in LOAD in order ti have some record random

maxgro
MVP
MVP

if you want 5 rows with 5 cities

F:

first 5 load *;

load *

from yourexcel

Where not Exists (City);