Data Modeling Thoughts

[alec1982]

Hi guys,

I have two tables and simply I want to join them using couple of columns. data within the tables can be joined based if one of the two columns match or both.. Any idea on how to do that?

Table1:

SO  RepName Amount

1      John               250

2      Jared              300

3      Mike                150

Table2:

SO    RepName   AR

1       John            ABC       

1       Alicia           KLM

2       Jared           yui

4       Mike             qwe

Thxs,

Alec

[MK_QSL]

What is SO here?

[its_anandrjs]

You can join with common keys and check would be unique.

[its_anandrjs]

In this two tables i believe one is master and second one is transaction table please clear why SO has different behavior and values.

[its_anandrjs]

You can load your table by joining them but data in table is not in proper check and confirm please

LOAD * Inline

[

SO,  RepName, Amount

1,      John,               250

2,      Jared,              300

3,      Mike,               150

];

Join

Table2:

LOAD * Inline

[

SO,    RepName,   AR

1 ,      John,           ABC      

1,       Alicia,          KLM

2,       Jared,          yui

4,       Mike,          qwe

];

[alec1982]

Hi guys,

Thank you for your help but i should've been more clear on what i need. I need to keep both tables within the QV and not join them into one table.. SO is Sales Order nr and it is unique on the first table only.

Thxs

[its_anandrjs]

Then leave the tables in the link condition with any same key like SO.

[alec1982]

That will create Synthetic keys which is wrong..

[MK_QSL]

OK... One question... Is SO unique to 1st Table?

Why I am asking, is SO 1 from Table 1 is Unique, so how come SO 1 in table 2 is having two different representative?

[Joseph_Musekura]

Hi,

Please check examples given in this link  " Understanding Join, Keep and Concatenate".

http://community.qlik.com/thread/39177    

/joseph