Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Tags (2)
2 Replies

Re: Exclude rows in load statement

maybe

LOAD *

FROM source

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

Gabriel
Valued Contributor II

Re: Exclude rows in load statement

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

Community Browser