HOW TO LOAD DISTINCT VALUES IN QV LOAD

vikasmahajan — Fri, 21 Dec 2012 12:46:58 GMT

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

Re: HOW TO LOAD DISTINCT VALUES IN QV LOAD

CELAMBARASAN — Fri, 21 Dec 2012 13:49:03 GMT

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;