concatenate

[Anonymous]

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 ?

[MayilVahanan]

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

[Anonymous]

Unfortunatly it doesn't work.

I don't know why

[v_iyyappan]

Hi,

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

Regards,

[Anonymous]

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

[#6]

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.

[Anonymous]

Perhaps I'm making some mistake, but after the storing and reload of the final table, I don't see the added records inside.

[#8]

Hi,

Your script should look something like this:

WithShipments:

Load

field1,

field2,

field3

rowno() as S.No

From WithShipmentsTable;

Concatenate

Load

field1,

field2,

field3

rowno() as S.No

Resident WithoutShipments where Exists(Customer,Customer);

Hope that helps.

Regards,

-Khaled.