Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude rows in load statement

Hello,

I'm loading data based on phone numbers from a file to analyse. The purpose is basically sorting the data(number of rows) down to dates.

That isn't a problem but what I want to do first, preferably in the load, is to exclude the first 10 rows imported for each distinct phone number.

Any ideas?

Regards, Jon

2 Replies
MarcoWedel

maybe

LOAD *

FROM source

Where Autonumber(RecNo(),[phone number]) > 10;

Gabriel
Partner
Partner

Hi,

May be try something like this

//Just the telephone number with distinct. This will give the number of DISTINCT tel number

Final_Table:

LOAD

    Distinct

    [Telephone Number]           

FROM

[Telephone Number Data.xlsx]

(ooxml, embedded labels, table is Worksheet)

WHERE AutoNumber(RecNo())>10;

Then

//Left Join the rest of the fields with the 1st load

LEFT JOIN(Final_Table)

LOAD

    [Telephone Number]

    ,[Customer Name],

    Country,

    Date

FROM

[Telephone Number Data.xlsx]

(ooxml, embedded labels, table is Worksheet)

WHERE Exists([Telephone Number])

;

Hope this helps