Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Fields No found

Hello everyBody ,

I concatenate 3 table , but when i try to load , my fields , the system indacate that i have a error with pivot_nom fields , However it seems to me that the script is just

Please See the attachement ,

Thank U

Sans titre.png

1 Solution

Accepted Solutions
Not applicable

Re: Fields No found

I Solve the problem , i group by CCN

16 Replies
MVP
MVP

Re: Fields No found

Hi,

The script is fine and I am able to reload your Qlikview file without any changes.

Regards,

Jagan.

Not applicable

Re: Re: Fields No found

I attaeched to wrong file sorry ,

Please , See thos new attached

er_mohit
Honored Contributor II

Re: Fields No found

have you write [@3] look like this means inside square bracket

or write this way

left join(Pivot)

Load

Pivot_Nom,

//Pivot_Prenom,

//Pivot_Nom,

//CCN,

sum([NOMBRE DE TITRES EN VOTE SIMPLE]) as Units

resident Nominatif group by Pivot_Nom ;

drop table Nominatif ;

Not applicable

Re: Fields No found

Yes , But its doesnt Work

Not applicable

Re: Fields No found

you do a resident load from Table1

Do you have a field called @3 in Table1 (I assume you have done a AS when populating the first time Table1) ?

Fabrice

Not applicable

Re: Fields No found

Yes i do a resident load from table 1

Not applicable

Re: Fields No found

Try field name without any special characters!

or field name in Square bracket if you are using any special characters.

I have Personal edition of Qlikview so I can open your qvw file.


Not applicable

Re: Re: Fields No found

Its doesnt Work

SET ThousandSep=' ';

SET DecimalSep=',';

SET MoneyThousandSep=' ';

SET MoneyDecimalSep=',';

SET MoneyFormat='# ##0,00 €;-# ##0,00 €';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.';

SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.';

Nominatif:

LOAD [CODE EMETTEUR],

     CCN ,

     [CODE VALEUR],

     EUROCLEAR,

     [NOMBRE DE TITRES EN VOTE SIMPLE]

FROM

(biff, embedded labels, table is Feuil1$);

Pivot:

LOAD

@3 as Pivot_Nom,

@4 as Pivot_Prenom,

@11 as CCN

FROM

(biff, no labels, table is Feuil1$);

Concatenate

LOAD

@3 as Pivot_Nom,

@4 as Pivot_Prenom,

@12 as CCN

FROM

(biff, no labels, table is Feuil1$);

Concatenate

LOAD

@3 as Pivot_Nom,

@4 as Pivot_Prenom,

@13 as CCN

FROM

(biff, no labels, table is Feuil1$);

Concatenate

LOAD

@3 as Pivot_Nom,

@4 as Pivot_Prenom,

@14 as CCN

FROM

(biff, no labels, table is Feuil1$);

left join

Load

//Pivot_Prenom,

Pivot_Nom,

sum([NOMBRE DE TITRES EN VOTE SIMPLE]) as Units

resident Nominatif ;

drop table Nominatif ;

// Pivot:

//LOAD

//

// @3 as Pivot_Nom,

//   @4 as Pivot_Prenom,

//     @5 as Pivot_Datenaissance,

//     @6 as Pivot_Matricule,

//     @7 as Pivot_NouvelleMatriculation,

//     @8 as Pivot_CodeValoptec,

//     @9 as Pivot_NumeroSecuriteSocial,

//     @10 as Pivot_MatriculePee,

//     @11 as Pivot_CCN1,

//     @12 as Pivot_CCN2,

//     @13 as Pivot_CCN3,

//     @14 as Pivot_CCN4, 

//     //LOOKUP('Nb total de parts', 'CCN', [@11], 'TABLE1') + LOOKUP('Nb total de parts', 'CCN', [@12], 'TABLE1') as No_Of_Units,

//     @15 as Pivot_HolderIdentifier,

//     @16 as Pivot_IdTitulaireSG,

//     @17 as Pivot_NumSSInt1,

//     @18 as Pivot_NumSsInt2,

//     @19 as Pivot_MatriculeEntreprise,

//     @20 as Pivot_HSBCNumIdentifiant2,

//     @21 as Pivot_EsapEmployee,

//     @22 as Pivot_EsppID,

//     @23 as Pivot_IrishEmplyRef,

//     @24 as Pivot_KoreeWorkerID,

//     @25 as Pivot_ChemiglassId,

//     @32 as Pivot_ref2

//FROM

//

//(biff, no labels, table is Feuil1$);

Not applicable

Re: Fields No found

Yes, Sofiane, you do a resident load

But, what are the fields of Table1 ?

Exit your script, go to table viewer and see if you get @3 or sth else. I would be surprised that you let this name in the table.

As other said, if so, encapsulate the field name with square brackets [].

If it still does not work, rename the field in Table1 when loading it :  @3   as col3  (perhaps this special name is not authorized in resident load)

Fabrice

Community Browser