topic Re: concatenate in QlikView

concatenate

Anonymous — Tue, 20 Nov 2012 17:55:32 GMT

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

MayilVahanan — Tue, 20 Nov 2012 18:10:00 GMT

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

Anonymous — Tue, 20 Nov 2012 18:17:12 GMT

Unfortunatly it doesn't work.

I don't know why

Re: concatenate

v_iyyappan — Tue, 20 Nov 2012 18:37:01 GMT

Hi,

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

Regards,

Re: concatenate

Anonymous — Tue, 20 Nov 2012 19:08:43 GMT

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

Wed, 21 Nov 2012 03:31:18 GMT

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.

Re: concatenate

Anonymous — Wed, 21 Nov 2012 09:47:11 GMT

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

Re: concatenate

Thu, 22 Nov 2012 06:22:30 GMT

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.