Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!