Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Yulia_Ut
Contributor II
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?

Labels (2)
1 Solution

Accepted Solutions
StarinieriG
Partner
Partner

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
StarinieriG
Partner
Partner

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

Yulia_Ut
Contributor II
Contributor II
Author

You are absolutely right.

Thank you so much! It works!