Loading specific recoreds from Flat file to Qlikview

[Anonymous]

Is there a way to choose the rows that needs to be laded into Qlikview.

Will I be able to restrict the data getting into the application .

I have a flat file and that is space separated.  wanted to load only the lines that start with a number 0,1,2 and eliminate all other rows in the file.

[swuehl · Accepted solution]

Sure, just add a WHERE clause to your load:

LOAD * INLINE [

A B

1 asdsa

2 sdfsd

5 sdf sd

3 sdfs

1 sdf

7 dfgdf

0 sdfsd

] (delimiter is ' ')

where Match(A,0,1,2);