HOW TO ADD A FILTER CONDITION WHILE LOADING THE DATA VIA EDIT SCRIPT

[sushil353]

HI EXPERTS,

i am facing problem while loading the data via edit script. i want to apply a filter condition like

PRD_YIELD_OP_TYPE_SUMMARY.stage_code = 1

and PRD_YIELD_OP_TYPE_SUMMARY.op_vernum = 1

LOAD

"LOCATION_CODE",

"AREA_CODE"

,

"PRD_ID"

,

"STAGE_CODE"

,

"OP_GROUP_ID"

,

"OP_TIME_ID"

,

"OP_VERNUM",

"NO_NDF_NDR_DEFECTS"

;

SQL

SELECT *

FROM "DW_OWNER"."PRD_DFCT_ORIGIN_YIELD_SUMMARY";

"S_ORIG_CODE",

[#2]

Hi Sushil

try using where clause in edit script

[#3]

Hi,

LOAD
"LOCATION_CODE",
"AREA_CODE",
"PRD_ID",
"STAGE_CODE",
"OP_GROUP_ID",
"OP_TIME_ID",
"OP_VERNUM",
"NO_NDF_NDR_DEFECTS";
SQL
SELECT * FROM "DW_OWNER"."PRD_DFCT_ORIGIN_YIELD_SUMMARY"
where STAGE_CODE = 1 and OP_VERNUM = 1 ;

Do that

Regards,

Chandra

[sushil353]

THANKS CHANRED