topic Exctract rows from excel random in QlikView

Exctract rows from excel random

Anonymous — Tue, 16 Feb 2016 11:00:17 GMT

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.

Here there is a xls sample of some rows.

Thanks

sunny_talwar — Tue, 16 Feb 2016 19:00:35 GMT

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 — Tue, 16 Feb 2016 19:18:15 GMT

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

maxgro — Tue, 16 Feb 2016 19:53:11 GMT

if you want 5 rows with 5 cities

first 5 load *;

load *

from yourexcel

Where not Exists (City);