topic Exclude rows in load statement in QlikView

Exclude rows in load statement

Fri, 09 Jan 2015 18:37:38 GMT

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

MarcoWedel — Fri, 09 Jan 2015 19:29:43 GMT

maybe

LOAD *

FROM source

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

Gabriel — Sun, 11 Jan 2015 23:14:07 GMT

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