Not fully loading from .TXT file

Yulia_Ut — Sat, 16 Nov 2024 20:03:49 GMT

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?

Re: Not fully loading from .TXT file

StarinieriG — Wed, 18 Sep 2019 08:39:01 GMT

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

Re: Not fully loading from .TXT file

Yulia_Ut — Wed, 18 Sep 2019 08:58:56 GMT

You are absolutely right.

Thank you so much! It works!

topic Re: Not fully loading from .TXT file in QlikView

Not fully loading from .TXT file

Re: Not fully loading from .TXT file

Re: Not fully loading from .TXT file