topic Re: Probléme With STORE + QVD in QlikView

Probléme With STORE + QVD

Tue, 15 Oct 2013 07:52:21 GMT

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 😃

Re: Probléme With STORE + QVD

Tue, 15 Oct 2013 07:57:58 GMT

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);

Re: Probléme With STORE + QVD

tresB — Tue, 15 Oct 2013 07:58:47 GMT

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

Re: Probléme With STORE + QVD

Tue, 15 Oct 2013 08:13:15 GMT

It's Work Thank U Guys