9 Replies Latest reply: Jul 21, 2011 6:30 AM by Kaushik Solanki RSS

    Loading multiple QVD file.

    Shubham Kumar

      Hi Everyone,

       

       

      Here I am trying to load almost 12 QVD files in one report. but the report is not reloading completely , it get stuck some where doesn't load completely. Below is the overview how I am writing the code:

       

       

       


      FMOverunder2011:

       

      Load from Loading multiple QVD file.(qvd);<br />Load* from Loading multiple QVD file.(qvd);<br />Load* *from Loading multiple QVD file.(qvd);
      Load *from Loading multiple QVD file.(qvd);
      Load *from Loading multiple QVD file.(qvd);
      Load *from Loading multiple QVD file.(qvd);
      Load *from Loading multiple QVD file.(qvd);
      Load *from Loading multiple QVD file.(qvd);
      Load *from Loading multiple QVD file.(qvd);
      Load *from Loading multiple QVD file.(qvd);
      Load *from Loading multiple QVD file.(qvd);  Best Regards Shubham Kumar

       

       

      Message was edited by: Jason Long

        • Loading multiple QVD file.
          Kaushik Solanki

          Hi,

           

              I think your problem might be same as this. Have a look at the below post.

           

              http://community.qlik.com/message/134268#134268

           

          Regards,

          Kaushik Solanki

            • Loading multiple QVD file.
              Shubham Kumar

              Thanks Solanki,

               

              However that doen't not satisfies my question. Could you please elabrote your answer. I see you have said there may be same field's which would be trying to join from each other caused that problem. but can you help with the answer how to resolve that problem.

               

              Thanks & Regards

                • Loading multiple QVD file.
                  Kaushik Solanki

                  Hi,

                   

                     IN that case you need to identify the same fields from all the qvd's.

                   

                     You need to create a  datamodel, and according to that you can keep the names of the fields same in those tables which will join the other table.

                   

                     For example say i have 3 tables with few same fields. so i will use them like this.

                   

                     Table1:

                      Load Field1, Field2 from ABC.qvd;

                   

                     Table2:

                     Load FIeld1, Field2 as Field_2, field3 from PQR.QVD;

                   

                     Table 3:

                      Load Field1, Field2 as Field__2, field3 as Field_3 from xyz.qvd;

                   

                     As you can see here i have renamed the field which i dont want to use for joinning the tables and i have kept Field1 as same in every table cause i want tables to join with field namd field1.

                   

                     Hope you understand.

                   

                  Regards,

                  Kaushik Solanki

                    • Loading multiple QVD file.
                      Shubham Kumar

                      Hi Solanki,

                       

                      thanks for the reply. I tried the same thing before and after your suggestion as well. But same thing happend. more over you have suggested me to

                      Table1:

                          Load Field1, Field2 from ABC.qvd;

                       

                         Table2:

                         Load FIeld1, Field2 as Field_2, field3 from PQR.QVD;

                       

                         Table 3:

                          Load Field1, Field2 as Field__2, field3 as Field_3 from xyz.qvd;

                       

                      Where we have very long list of Field name which is hard to put in each QVD load since I have to laod more than 12QVD. instead of that I have used Load * from abc.qvd.

                       

                      Table 1:

                      Load * from abc.qvd

                      Table 2.

                      Load * from xyz.qvd

                       

                      Is that correct?