topic Re: How to using load script to filter Reporting_Code<10026 ? in QlikView

How to using load script to filter Reporting_Code<10026 ?

Wed, 20 Apr 2016 03:43:55 GMT

Hi All

I have below code :-

LOAD @1:13,

@14:46,

@106:122,

@123:n as Reporting_Code

FROM

(fix, codepage is 1252, no eof);

it will display Reporting_Code as below :-

10000

10011

10026

10030

My Question is what is the script i need to add , so that it will only keep those Reporting Code less then 10026 ? So that my QV Doc will only have 2 row of record.

Paul ( I am using my friend account as my account cannot log in )

Re: How to using load script to filter Reporting_Code<10026 ?

Wed, 20 Apr 2016 03:44:53 GMT

my QV Doc

Re: How to using load script to filter Reporting_Code<10026 ?

jonas_rezende — Wed, 20 Apr 2016 12:06:08 GMT

Hi, Eksa Susanto.

Utilize clause where like below.

LOAD @1:13,

@14:46,

@106:122,

@123:n as Reporting_Code

FROM

(fix, codepage is 1252, no eof)

where

@123:n < 10026;

I hope this helps!