7 Replies Latest reply: Nov 22, 2012 1:23 AM by Syed Khaled Shahbaaz RSS

    concatenate

    steve peroni

      Hi,

      I've a Sales table which contains all the customers which have shipments. But not all the customers. I would add to this table all the customers without shipment.

       

      For example

       

      Shipmenttable:

      Customer,    

           Date ,

               PArt,

               Type ,  all the other fields

      from  ......

       

       

      concatenate

      load Customer from MY_MASTER_DATA      ....

      where not exists(Customer);

       

      but it doesn't produce anything.

      What I'm doing wrong ?

        • Re: concatenate
          Mayil Vahanan Ramasamy

          HI

           

          Try like this

           

          Shipmenttable:

          Customer,   

               Date ,

                   PArt,

                   Type ,  all the other fields

          from  ......

           

           

          concatenate

          load Customer from MY_MASTER_DATA      ....

          where not exists(Customer,Customer);

           

          Hope it helps

          • Re: concatenate
            Iyyappan v

            Hi,

             

            Mayil suggestion is correct Otherwise Can u provide a sample file to solve ur requirments.

             

            Regards,

              • Re: concatenate
                steve peroni

                Hi,

                I found the problem: it was my mistake, I dropped the second table and I didn't see the right result.

                I'm sorry and thanks to everyone who spent time to help me.

                What I know now, is that the "added" records are only in memory. Wanting to have a physical table with all the records, what should I do ?

                 

                Thanks for your help

                 

                 

                  • Re: concatenate

                    Hi,

                     

                    You can store the table you just created by concatenation into a qvd file.

                    Use the STORE keyword for this.

                     

                    Try something like :

                     

                     

                    Shipmenttable:

                    Customer,   

                         Date ,

                             PArt,

                             Type ,  all the other fields

                    from  ......

                     

                    concatenate

                    load Customer from MY_MASTER_DATA      ....

                    where not exists(Customer,Customer);

                     

                    Store Shipmenttable into Shipmenttable.qvd (qvd);

                     

                    This will generate a QVD file for your result table.

                     

                    Alternatively, you can just add all the fields from Shipmenttable into a table box and export it to Excel.

                     

                    Hope that helps.

                     

                    Regards,

                     

                    -Khaled.