topic Re: Table not found in QlikView

Table not found

Mon, 04 Nov 2013 08:45:55 GMT

Hello ,

I have this error with my table someone have a idea

THANK U

Signalitique_reference:

LOAD

[ref matricule],

[ref id ss],

     [ref nom],

[ref prenom],

[ref Créé le]

FROM $(FilePath)\QV_Dev\Signalitique_reference.QVD (qvd);

//Utile 1 fois pour iniatialiser le projet

//Signalitique_reference:

//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)\data\Signalitique PS\24 - SIGNALETIQUE GROUPE*.xls]

//(biff, no labels);

//

//

//

//STORE Signalitique_reference INTO $(FilePath)\QV_Dev\Signalitique_reference.QVD;

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)\data\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)\QV_Dev\RefSign.QVD;

drop table RefSign ;

LET vOldRecords = QvdNoOfRecords('$(FilePath)\QV_Dev\Signalitique_reference.QVD');

save:

CONCATENATE (Signalitique_reference) LOAD Distinct

*

FROM $(FilePath)\QV_Dev\RefSign.QVD (qvd)

WHERE NOT Exists([ref matricule]);

LET vNewRecords = NoOfRows('Signalitique_reference') - $(vOldRecords);

STORE save INTO $(FilePath)\Dev\Signalitique_reference.QVD;

Re: Table not found

Aurelien_Martinez — Mon, 04 Nov 2013 08:57:15 GMT

Hi,

You have this error becouse your table "save" did not existe.

This script :

CONCATENATE (Signalitique_reference) LOAD Distinct

FROM $(FilePath)\QV_Dev\RefSign.QVD (qvd)

WHERE NOT Exists([ref matricule]);

concatenate the result of

LOAD Distinct

FROM $(FilePath)\QV_Dev\RefSign.QVD (qvd)

WHERE NOT Exists([ref matricule]);

to Signalitique_reference.

If you want to store the result of the contenation write that:

STORE Signalitique_reference INTO $(FilePath)\Dev\Signalitique_reference.QVD;

Ps: See this article about Distinct and concatenate: DISTINCT can be deceiving » The Qlik Fix! The Qlik Fix!

Regards,

Aurélien

Re: Table not found

Gysbert_Wassenaar — Mon, 04 Nov 2013 08:59:24 GMT

There is no table named save since that date was concatenated into Signalitique_reference.

Re: Table not found

Mon, 04 Nov 2013 09:35:29 GMT

Hi Wzssenaar

Thank U for Ure answer ,Monthly i receive a wls File with a lot of information abour costmurs , so the goal is to set up a pivot table or reference table to add juste the new entries , to have a message like that : for example ( for octobre 4 customers are be add , for septembre 5 cust are been added ...)

for this

I use a concatenation of tables + qvd records

1st stage: I load my table reference

2nd stage: a month later, I reload the second example I have 2 new customers

3rd stage: a month later, I reload the table I get and I realize that I have 4 new customers , basically, he can not manage to save the last value, he reload and show me all news entries

do you have a idea to solve my problem thank u