topic NoConcatenate in QlikView

NoConcatenate

Tue, 19 Mar 2013 17:28:15 GMT

Hello

I have this attached file with two tables and one row in each.

Is there an easy way to do a join between them and just get records from the main table i.e. in this example I'm expecting Sector (GED Derivatives) from GCRS table and not from Commentary table.

Thanks for your help.

Re: NoConcatenate

Gysbert_Wassenaar — Tue, 19 Mar 2013 17:31:55 GMT

This will join the two tables, keeping all values from GCRS and only the matching records from Commentary

Commentary:

Load * Inline

[

Sector, Comments

GED Derivatives (GED), Some Comments

];

GCRS:

right join Load * Inline

[

Sector, GCRS_ID

GED Derivatives,1

];

If that's not what you want, you'll have to explain what you do want. A table that shows how the results should look would help.

Re: NoConcatenate

Wed, 20 Mar 2013 06:47:28 GMT

Hi,

Can you please explain in brief what exactly you want.

Regards,

Snehal Nabar

Re: NoConcatenate

Thu, 21 Mar 2013 11:06:17 GMT

Thanks Gysbert.

Is there a way I could achieve this without the join. I have a common column between two tables which Qlikview automatically links. I would like to use this automatic mapping and just extract the data out of the one table.