Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😃
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);
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);
Your RefSign table is getting auto concatenated to Signalitique_ref table. Place a NoConcatenate before the RefSign table and try.
It's Work Thank U Guys