topic Joining tables in QlikView

Joining tables

Anonymous — Wed, 14 May 2014 07:51:15 GMT

Hi All

Stuck on a school boy error!

I need to join a field to a facts table so it links to my table for example.

Table A contains

Car

Reg_No

Colour

Table B Contains

Price

Location

Engine Size

How can i add price to Table A ?

Or how can i link these 2 together without a connecting key?

Thanks

alexandros17 — Wed, 14 May 2014 07:54:01 GMT

I answer with an example:

Car Reg_No Colour

Ford 111 Red

Citroen 222 White

Price Location Engine Size

1000 France 150

1500 Italy 90

the resulting join will be:

Ford 111 Red 1000 France 150

Ford 111 Red 1500 Italy 90

Citroen 222 White 1000 France 150

Citroen 222 White 1500 Italy 90

And this will not help you ... you need a link between the 2 tables

Hope it helps