How to create relational join with multiple columns in framework manager

[mvn.balu]

Hi ,

Need help on create a connection  with multiple columns,   The problem is i have to tables table 1 and table 2 in the fileds like this

Table 1                                      Table 2
-------------                               -------------
licenseno_01                         Licenseno
licenseno_02
Licenseno_03
Licenseno_04

these are the Key columns.
so how to join these columns .
I try to join like this  but am not get the result
licenseno_01=Licenseno and licenseno_02=Licenseno and licenseno_03=Licenseno and licenseno_03=Licenseno


Please let me now is any other way to resolve this please.

[MFGF]

Hi,

You don't indicate what data values exist in any of these columns. Without knowing this it's nigh on impossible to advise you on how they can be used in a join. You don't have to give us real data - just a made-up example of the values in each column, and what you want to do with the result of the join.

Regards,

MF.

[mvn.balu]

Both tables having numeric values.

Assume table-2 has 10 distinct license numbers like 1,2,3,4,5,6,7,8,9,10 under "LICENSE_NO" column.

And the table-1 also have the same above license numbers and there may be possible to have NULLS also,
but those are splitted into multiple columns say,
under License No_1 ---> 2,4,5
         License No_2  ----> 1,3,6
         License No_3   --->  7
        License NO_4   --->  8, NULL, `10.

Not mandatory to have all those license numbers to be there in TABLE-2,  that what we have in Table-1...

[MFGF]

It looks to me like you need to have four role-playing versions of Table2 in your model - each joined to a different License_no column in Table1. It all depends on what result you need to achieve, though.

Regards,

MF.

[bi4u2]

I agree with MFGF. Create 4 alias tables in your database layer on Table 2 so that you can set up each of these 4 scenarios. Alias tables are meant to have their own independent join path.

[mvn.balu]

Hi i created the 4 alias and joined in Database view . but  while join these tow tables columns in the  query studio i am getting error like     RQP-DEF-0103          Cross joins (between query subjects .    Is mandatory to add those alias in to other view also ?

[bi4u2]

Well yes, you would need to create a query subject in your transformation/logical layer that refers to items in the Alias tables you created.

[pricter]

Instead of you using AND on your joins I think it should be a good idea to use OR in the join expression