Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

Not fully loading from .TXT file

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?

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Not fully loading from .TXT file

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

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Not fully loading from .TXT file

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

View solution in original post

Highlighted
New Contributor II

Re: Not fully loading from .TXT file

You are absolutely right.

Thank you so much! It works!