NoConcatenate

[#1]

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.

[Gysbert_Wassenaar]

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.

[#3]

Hi,

Can you please explain in brief what exactly you want.

Regards,

Snehal Nabar

[#4]

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.