HOW TO LOAD DISTINCT VALUES IN QV LOAD

[vikasmahajan]

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

[CELAMBARASAN · Accepted solution]

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;