Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
How i can remove the duplicate records from QVD ....Is there any possible way to do so !!!!!!!!
Sarfaraz
Hi,
use Distinct
Regards
Dear Max,
Can you put any example for my understanding ..........
Sarfaraz
Hi,
Try like this
Data:
LOAD DISTINCT
*
FROM DataSource;
OR
Data:
LOAD DISTINCT
Column1,
Column2,
'
'
'
FROM DataSource;
STORE Data INTO FileName.qvd;
Hope this helps you.
Regards,
Jagan.
Hi ,
Use DISTINCT Key word in load script
for eg:
Table:
load DISTINCT
clumn,
clumn
from data_tabel.xl;
thanks,
Raja
Hi Sarfaraz,
The Question is not Clear here, do you want to remove duplicates while loading or you want to remove Duplicate in existing QVD?
In 1st case as Jagan told above the is the solution and in
2nd case use incremental load concept
HEy,
I tried implememting incremental load but it is not giving expected result. I ahve attached the application. In that , i am getting values in SalesData1 but while concatenating it is fetching data from qvd of first occurence and not of last updated date as in case of Region é'.
thanks
pls share the file are else i will send a qvw with example EOD
Hey,
I have already shared my file in last reply.
Hi,
In the script by using the "Where exists(FieldName);" function possible to remove the duplicate records.
thanks,
Krish