topic Re: Error Fields in QlikView

Error Fields

Tue, 15 Oct 2013 09:07:57 GMT

Hey Evrybody

I have this Error , i m bloqued

//// Chargement des références


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




RefPee:
NOCONCATENATE
LOAD 
  @6 as [ref PEE matricule], 
  @5 as [ref PEE id ss],
     @2 as [ref PEE nom],
  @3 as [ref PEE prenom],
  '$(ProcessTime)' as [ref PEE Créé le]
FROM [$(FilePath)\fichier As\SG PEE\09 - PEE 02-10-13*.xls]
(biff, no labels);




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


drop table RefPee ;




CONCATENATE (PEE_ref) LOAD
  *
FROM $(FilePath)\Dev\RefPee.QVD (qvd)
WHERE NOT Exists([ref matricule]);






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




//Utile 1 fois pour iniatialiser le projet


//PEE_ref:
//LOAD 
// @1 as [ref PEE matricule], 
// @2 as [ref PEE id ss],
//    @6 as [ref PEE nom],
// @7 as [ref PEE prenom]
//FROM [$(FilePath)\fichier As\SG PEE\09 - PEE 02-10-13*.xls]
//(biff, no labels);
//
//STORE PEE_ref INTO $(FilePath)\Dev\PEE_ref.QVD

Thank U

Re: Error Fields

swuehl — Tue, 15 Oct 2013 09:13:03 GMT

Have you double checked that this field is part of the QVD?

And that it is correctly spelled (two accents? Cases?)?

edit:

You can use the script wizard to open the file and select the correct fields.

Re: Error Fields

Tue, 15 Oct 2013 09:21:10 GMT

normally I do that

Its doenst work

Re: Error Fields

swuehl — Tue, 15 Oct 2013 09:35:31 GMT

Does a

LOAD * FROM ... ;

work?

Re: Error Fields

Tue, 15 Oct 2013 09:58:21 GMT

The Programme Bloque in the creation of the table , I dont know why ??

PEE_ref:

LOAD

[ref PEE matricule],

[ref PEE id ss],

[ref PEE nom],

[ref PEE prenom],

[ref PEE Créé le]

FROM $(FilePath)\Dev\PEE_ref.QVD (qvd);

////To initialise the project

//PEE_ref:

//LOAD

// @1 as [ref PEE matricule],

// @2 as [ref PEE id ss],

// @6 as [ref PEE nom],

// @7 as [ref PEE prenom]

//FROM [$(FilePath)\fichier As\SG PEE\09 - PEE 02-10-13*.xls]

//(biff, no labels);

//STORE PEE_ref INTO $(FilePath)\Dev\PEE_ref.QVD;

Re: Error Fields

MayilVahanan — Tue, 15 Oct 2013 10:04:07 GMT

Try like this

LOAD * FROM $(FilePath)\Dev\PEE_ref.QVD (qvd);

And check the fields in qvd once.

Re: Error Fields

Tue, 15 Oct 2013 10:12:08 GMT

I dont Know Why But Its Work