Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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);