Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to using load script to filter Reporting_Code<10026 ?

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 )

2 Replies
Not applicable
Author

my QV Doc

jonas_rezende
Specialist
Specialist

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!