doubt to join two tables

Tue, 30 Aug 2011 13:39:46 GMT

Good Day!
Gentlemen,
I'm entering the world of qlick view now and I have some doubts.

I know that for some doubts are simple, however if they can help me be grateful.

I have two tables.

For example:

Table A:

Brand | Model | Value
22,000 Fiat Palio
Ford Fiesta 25,000
Fiat Palio -1200
Ford Fiesta -3520

Table B:
Brand | Source | Model | Year
2000 Ford Fiesta Americana
American Fiat Palio 2008
American GM Vectra 2010

I would like to join the tables, where the new structure would be as follows:

Brand | Source | Model | Year | Value Positive | Negative Value
American Fiat Palio 2008 22000 -1200
Ford Fiesta Americana 2000 25000 -3250
American GM Vectra 2010 0 0

If someone can get me an e-mail sent in Excel tables.

OBS.: How not to speak English using Google Translate. To get a better view of the table I created is better to translate from english to Portuguese, at least the tables.

I thank for your attention.

Jorge Rodrigues
jorge.rodrigues @ meltex.com.br

doubt to join two tables

Anonymous — Tue, 30 Aug 2011 13:49:17 GMT

qlik join the tabel using the name of fields , so your table are already join by fields Brand and Model

doubt to join two tables

Tue, 30 Aug 2011 14:28:26 GMT

Alfasierra,
Already got an example right here in the community that I think will help me.
I'll see if I put a clearer example of what I want.

topic doubt to join two tables in QlikView

doubt to join two tables

doubt to join two tables

doubt to join two tables