Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

doubt to join two tables

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

2 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

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.