Probléme With STORE + QVD

[#1]

Hello Guys

I have some probléme with my strore function  , I dont inderstand why ??,

this my qvd function :

// reference classe 
Signalitique_ref:
LOAD 
  [ref matricule], 
  [ref id ss],
     [ref nom],
  [ref prenom],
  [ref Créé le]
FROM $(FilePath)\Dev\Signalitique_ref.QVD (qvd);


// Reference siganlitique 

RefSign:
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]
(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;

SOS  PLease 

tHANK u 😃

[#2 · Accepted solution]

Hi,

When you create two tables with the same structure, they automatically concatenate.

In your example, "RefSign" is not created, data are concatenated in "Signalitique-ref"

Use :

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] 

(biff, no labels);

[tresB]

Your RefSign table is getting auto concatenated to Signalitique_ref table. Place a NoConcatenate  before the RefSign table and try.

[#4]

It's Work Thank U Guys