16 Replies Latest reply: Feb 26, 2014 6:16 AM by BEN BOURAHEL Sofiane RSS

    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

        • Re: Fields No found
          jagan mohan rao appala

          Hi,

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

           

          Regards,

          Jagan.

          • Re: Fields No found
            Mohit Sharma

            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 ;

            • 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

                • Re: Fields No found

                  Yes i do a resident load from table 1

                    • 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

                        • Re: Fields No found

                          Fabrice ,

                           

                          J'ai ajouté

                                Nom as Pivot_Nom,

                                Prenom as Pivot_Prenom

                          dans ma première table 1 : nominatif ,

                           

                          Et quand j 'essaye de load from resident table , il me prend pas le champs , Pivot_nom

                          J'ai tous essayé , meme avec des [] ;

                           

                          Je ne sais pas si tu as d'autres suggestions pour me débloquer car  je n'arrive pas a avancer ,

                           

                          Merci en tous  cas

                    • Re: Fields No found
                      Vinay Naran

                      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.


                        • 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
                          [C:\Users\benbours\Desktop\ProjetAs\Fichier de Test\Nominatif Example.xls]
                          (biff, embedded labels, table is Feuil1$);
                          
                          
                          Pivot:
                          
                          
                          LOAD
                          
                          
                          @3 as Pivot_Nom, 
                          @4 as Pivot_Prenom,
                          @11 as CCN
                          
                           FROM
                          [C:\Users\benbours\Desktop\ProjetAs\Fichier de Test\Pivot Example.xls]
                          (biff, no labels, table is Feuil1$);
                          
                          
                          Concatenate
                          LOAD
                          @3 as Pivot_Nom, 
                          @4 as Pivot_Prenom, 
                          @12 as CCN
                          
                          
                          FROM
                          [C:\Users\benbours\Desktop\ProjetAs\Fichier de Test\Pivot Example.xls]
                          (biff, no labels, table is Feuil1$);
                          
                          
                          Concatenate
                          
                          
                          LOAD
                          @3 as Pivot_Nom, 
                          @4 as Pivot_Prenom,
                          @13 as CCN
                          
                          
                          FROM
                          [C:\Users\benbours\Desktop\ProjetAs\Fichier de Test\Pivot Example.xls]
                          (biff, no labels, table is Feuil1$);
                          
                          
                          Concatenate
                          
                          
                          LOAD
                          @3 as Pivot_Nom, 
                          @4 as Pivot_Prenom,
                          @14 as CCN
                          
                          
                          FROM
                          [C:\Users\benbours\Desktop\ProjetAs\Fichier de Test\Pivot Example.xls]
                          (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
                          //[C:\Users\benbours\Desktop\ProjetAs\Fichier de Test\Pivot Example.xls]
                          //(biff, no labels, table is Feuil1$);