topic Re: QVD DELETE in QlikView

QVD DELETE

Wed, 16 Oct 2013 07:55:07 GMT

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

Re: QVD DELETE

Anonymous — Wed, 16 Oct 2013 08:30:24 GMT

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

Re: QVD DELETE

Wed, 16 Oct 2013 08:40:55 GMT

Hey Bill

for example , when i delete a Columns like a name of my clients his age ....

Re: QVD DELETE

Anonymous — Wed, 16 Oct 2013 08:55:21 GMT

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

Re: QVD DELETE

Wed, 16 Oct 2013 14:16:54 GMT

THANK U BILL