Not fully loading from .TXT file

[Yulia_Ut]

Hello.

In my .txt file (attached to this post in .zip file) I have 18 useful strings in the table with pseudo-graphics. But finally in .qvw I got only first 12 strings.

What I do:

LOAD
trim(@2) as [Material],
@3 as [Description],
@4 as [farm],
@5 as Base,
@6 as [vdv],
@7 as [O],
@8 as [DocMtr],
@9 as [Pos.],
@10 as [Date 1],
@11 as [Date 2],
@12 as [Date 3],
@13 as Quantity,
@14 as val,
@15 as [Qnt/EIV],
@16 as EIV,
@17 as [Sum BB],
@18 as Order,
@19 as Supplier,
@20 as [DocNum.],
@21 as Link,
@22 as Text,
@23 as Part,
@24 as Mvz,
@25 as User

FROM
data\PTJ0000019239.txt
(txt, codepage is 1251, no labels,no eof, delimiter is '|', header is 16 lines) where isnum(trim((@2)));

What I've made wrong? I've analyzed the .txt file: it hasn't hidden symbols or something unusual. In my load I use "no eof".

By the way in the first 12 strings in the column "Material" consist only digits, and later till 18th are mixed with symbols. Is it possible, that QlikView stops reading because of that?

[StarinieriG · Accepted solution]

Hi

it happens because there is a where condition where isnum(trim((@2))) that exclude those rows.

You could use this where instead 

where Match(trim((@2)),'Material')=0 and Len(PurgeChar(trim((@2)),'*-'))>0

[Yulia_Ut]

You are absolutely right.

Thank you so much! It works!