Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 )
my QV Doc
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!