Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have two File 1. XLS data & file 2.xls , Primary i store a file1. QVD from file1.xls , in the second time i charge a référence table from file1.qvd
I concatanate tables to have the elements that have been added
My problemes is when i delete some elements from file1.xls they are not removed from my table in QVW ??
Someone have a Idea
Signalitique_ref:
LOAD
[ref matricule],
[ref id ss],
[ref nom],
[ref prenom],
[ref Créé le]
FROM $(FilePath)\Dev\Signalitique_ref.QVD (qvd);
//Signalitique_ref:
//LOAD
// @1 as [ref matricule],
// @2 as [ref id ss],
// @6 as [ref nom],
// @7 as [ref prenom]
//FROM [$(FilePath)\fichier As\Signalitique PS\24 - SIGNALETIQUE GROUPE*.xls]
//(biff, no labels);
//
//STORE Signalitique_ref INTO $(FilePath)\Dev\Signalitique_ref.QVD;
RefSign:
NOCONCATENATE
LOAD
@1 as [ref matricule],
@2 as [ref id ss],
@6 as [ref nom],
@7 as [ref prenom],
'$(ProcessTime)' as [ref Créé le]
FROM [$(FilePath)\fichier As\Signalitique PS\24 - SIGNALETIQUE GROUPE*.xls] // pourquoi on refait ca alors qu'on a déja chargé les champs dans un siganlitique_ref.qvd
(biff, no labels);
STORE RefSign INTO $(FilePath)\Dev\RefSign.QVD;
drop table RefSign ;
CONCATENATE (Signalitique_ref) LOAD
*
FROM $(FilePath)\Dev\RefSign.QVD (qvd)
WHERE NOT Exists([ref matricule]);
STORE Signalitique_ref INTO $(FilePath)\Dev\Signalitique_ref.QVD;
Thank U
Ben
So are you saying for example that your original xls has say 4 columns called ColA, ColB, ColC & ColD that are loaded in your script and stored in a QVD.
If you now delete a column, say ColB, from the xls, that will not affect the stored QVD. As in it will still contain ColB.
Then later you load another xls and concatenate onto the previously stored QVD using a CONCATENATE LOAD *, the * will load all columns from the QVD including the ColB.
I hope I have understood your question ok, if not then please clarify.
Best Regards, Bill
Ben
When you say:
My problemes is when i delete some elements from file1.xls they are not removed from my table in QVW ??
Could you advise what kind of elements you mean ?
Rows ?
Columns ?
Field Values ?
Something else ?
Best Regards, Bill
Hey Bill
for example , when i delete a Columns like a name of my clients his age ....
Ben
So are you saying for example that your original xls has say 4 columns called ColA, ColB, ColC & ColD that are loaded in your script and stored in a QVD.
If you now delete a column, say ColB, from the xls, that will not affect the stored QVD. As in it will still contain ColB.
Then later you load another xls and concatenate onto the previously stored QVD using a CONCATENATE LOAD *, the * will load all columns from the QVD including the ColB.
I hope I have understood your question ok, if not then please clarify.
Best Regards, Bill
THANK U BILL