6 Replies Latest reply: Mar 20, 2011 1:38 PM by samirks27 RSS

    Loading multiple QVD files and rowno()

      Hi All,

      I am loading multiple QVD files.I have 4 QVD files which has 8 records. I am putting rowno() funtion to generate line no which is showing 26 records where as all QVD files have only 8 records, I am attaching the screen-shot of the activity.

      Please let me know do you want all other files like CSV files, QVD files and QVW files.

      Thanks

      Samir

       

       

       

       

       

       



       

       



        • Loading multiple QVD files and rowno()
          Manesh KHOT

          Hi ,

          Just try this one and not success then send me ur file with application.

           

          For each File in filelist('D:\QlikView_Pratice\Loading-multiple-QVD-files\CSV-Files\*.csv')

          TableName:

          LOAD

          *

          FROM

          [$(File)]

          (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

          //STORE TableName INTO $(File). qvd (qvd);

          Next

          STORE TableName INTO $(File). qvd (qvd);

            • Loading multiple QVD files and rowno()
              Manesh KHOT

              Sorry ignore previous one,

               

              Just try this one and not success then send me ur file with application.

               

               

              For each File in filelist('D:\QlikView_Pratice\Loading-multiple-QVD-files\CSV-Files\*.csv')

              TableName:

              LOAD

              *

              FROM

              [$(File)]

              (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

              STORE TableName INTO $(File). qvd (qvd);

              drop table TableName;

              Next

                • Loading multiple QVD files and rowno()

                  Thanks Mahesh, your suggestion worked for me.

                  Once agian, heartiest thanks for your attention.

                  • Loading multiple QVD files and rowno()

                    Hi Mahesh,

                    It will generate the qvd and will place the file in the following folder:

                    'D:\QlikView_Pratice\Loading-multiple-QVD-files\CSV-Files'

                    I want to more qvd file to some other folder like:

                    ''D:\QlikView_Pratice\Loading-multiple-QVD-files\QVD-Files'

                    How can I move file to another location?

                    Thanks

                    Samir

                      • Loading multiple QVD files and rowno()
                        Manesh KHOT

                        Hi,

                        U can use the

                        Store TableName into Path\FileNAme.qvd;

                        Path is ur physical path(Full)

                          • Loading multiple QVD files and rowno()

                            Hi Mahesh,

                            I got the answer from Jonathan, meanwhile I am writing my requirement and where are you wrong:

                            **************************************************************************************************************************

                            For each File in filelist('D:\QlikView_Pratice\Loading-multiple-QVD-files\CSV-Files\*.csv')

                            TableName:

                            LOAD

                            *

                            FROM

                            [$(File)]

                            (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

                            STORE TableName INTO $(File).qvd (qvd);

                            drop table TableName;

                            Next

                            ************************************************************************************************************************

                            here if you will debug the code , will find file name as whole path in "$(File);"

                            So, we can not use it here. filename() function is also not working here

                            So, take substring function and find the file name and store into the desired path.

                            I will forward you the Jonathan's code or link later.

                            Thanks

                            Samir