Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have this problem.
from 3 csv I charge the situation of the incidents for my customer.
the csv are :
Incident Rised on Month
Incident Closed on Month
Incident Open ytd
I recharged all CSV in one QVD with incremental load where ID not Exist
is it possible, delete all Incident Open ( field Incident Status = 'OPEN' ) from QVD before to recharge the CSV :INCIDENT OPEN YTD ?
The sequence would is :
1)charge Incident Rised csv
join with incident Closed csv
join with QVD
2) DELETE rows with Incident Status = OPEN
3) charge Incident Open csv
join with QVD
thanks in advanced
no, you can't delete from a .qvd file
2) should be a residente load (or some other method) to filter the non OPEN incident
1)
Tab1:
charge
..........
2)
Tmp: noconcatenate load * resident Tab1 where not match(IncidentStatus, 'OPEN');
drop table Tab1;
rename table Tmp to Tab1; // now in Tab1 you don't have open incident
3)
.....
no, you can't delete from a .qvd file
2) should be a residente load (or some other method) to filter the non OPEN incident
1)
Tab1:
charge
..........
2)
Tmp: noconcatenate load * resident Tab1 where not match(IncidentStatus, 'OPEN');
drop table Tab1;
rename table Tmp to Tab1; // now in Tab1 you don't have open incident
3)
.....
thanks