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

[alec1982]

Hi guys,

thank you all for your help. I guess i found what I need by concatenate the two tables and filter based on the two columns listed above. This has been a great solution so far. Thxs for all your help!

[preminqlik]

just concatenate it..

[its_anandrjs]

Concatenate is good solution but i believe you have to make the link tables and then use the tables but depend on the table performance after join or concatenate how you use the tables.

And when concatenate make a flag field in both the tables like below

Table1:

LOAD *,'Tab1' as Flag;

LOAD * Inline[

SO, RepName, Amount

1,  John,    250

2,  Jared,   300

3,  Mike,    150];

Concatenate

Table2:

LOAD *,'Tab2' as Flag;

LOAD * Inline[

SO, RepName, AR

1,  John,    ABC      

1,  Alicia,  KLM

2,  Jared,   yui

4,  Mike,    qwe];

Regards

[Anonymous]

Hi,

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

you can face a problem do to concatenating the tables,you can't show the reports based on AR dimension,please check the requirement how you want to create .reports.after check the data model,

Thanks

SHAIK

[Joseph_Musekura]

Hi,

Jsut a small notice.

once your are OK with an answer remember to mark the question as answered

Regards,

[alec1982]

Thank you for your reminder.. Even I am the one who created this discussion I am not able to close it with correct answer. the option doesn't show on my screen while i am logged in. Any idea?

[Joseph_Musekura]

Hi,

I am not sure that I think you need to mark a correct answer before other steps