Skip to Content
avatar image
Former Member

Conditional Joins

Can the Universe do conditional join? Can you use conditional statements when editing a join expression? i.e. If (condition; TableA.columnA=TableB.columnA; TableA.columnA=TableB.columnB)

Thanks,

Jimmy

Edited by: Jimmy on May 21, 2009 9:58 PM

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 21, 2009 at 08:06 PM

    Hi Jimmy,

    You can do complex joins, by editing them in the join window.

    for instance:

    (
    (tableA.columnC="test" AND tableA.columnA=tableB.columnA)
    OR 
    (tableA.columnC<>"test" AND tableA.columnA=tableB.columnB)
    )

    You need to set the cadinality first changing this or the selected columns will reset you complex join.

    Regards

    Alan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Jimmy,

      you could this by writing case statments in the objetcs.

      Example: If you have three tables connected and based on condition you can choose the values from different tables.

      Case when table1.col = 'X' then table2.measure

      else table3.measure

      end

      Hope this will help you.

      Cheers,

      Ravichandra