Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Contributor II

concatenate

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 ?

7 Replies

Re: concatenate

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

bibopipo
Contributor II

Re: concatenate

Unfortunatly it doesn't work.

I don't know why

v_iyyappan
Valued Contributor

Re: concatenate

Hi,

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

Regards,

bibopipo
Contributor II

Re: concatenate

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

Not applicable

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.

bibopipo
Contributor II

Re: concatenate

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

Not applicable

Re: concatenate

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.

Community Browser