Discussion Board for collaboration on QlikView Scripting.
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.
May be use Sample 5 before the LOAD statement to randomly select 5 rows from your table.
LOAD [Account Code],
You can use SAMPLE sentence in LOAD in order ti have some record random
if you want 5 rows with 5 cities
first 5 load *;
Where not Exists (City);