Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
DEAR ALL
I HAVE FOLLOWING RECORDS
DOC NO PROD CD QTY BAISIC TAX
------------------------------------------------------------
123 XYZ 10 100 120
123 ABC 20 200 120
123 PQR 30 300 120
120 TAX IS COMMON FOR DOC NO 123 NOW WHILE LOADING IN QV I WANT ONLY 120 SHOULD TAKE
DISTINCT PLEASE GUIDE ME HOW TO ACHIVE THIS IN QV RELOAD.
REGARDS AND THANKS
VIKAS
Split the table as like below
TempTable:
Load
[DOC NO],[PROD CD],QTY,BAISIC, TAX
From DataSource;
Table1: //Except TAX
Load
[DOC NO],[PROD CD],QTY,BAISIC
Resident TempTable;
Table2:
Load Distinct [DOC NO], TAX
Resident
TempTable;
Drop Table TempTable;
Split the table as like below
TempTable:
Load
[DOC NO],[PROD CD],QTY,BAISIC, TAX
From DataSource;
Table1: //Except TAX
Load
[DOC NO],[PROD CD],QTY,BAISIC
Resident TempTable;
Table2:
Load Distinct [DOC NO], TAX
Resident
TempTable;
Drop Table TempTable;