Skip to Content
avatar image
Former Member

How to create a subquery in the where in the graphical view.

Hello everyone, I have a requirement, I need to do a subquery in the "where" of the query but I would like to be able to do in the graphical views of SAP HANA Studio. Can anyone help me in this? Regards, Alfonso

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 12, 2017 at 08:10 PM

    Hello,

    Try Calculated Column with complex IF structure. It would be much easier if you plan it before you code.
    After that replace original column with calculated one if needed.

    Regards,
    Mateusz.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Good but make sure that you are using the number of records that you want to retrive is correct (from what I see you are using inner join).

      You are using Filters, if you don't need those rows from POR1 then it's better solution than flag-type calculated column (less calculations).

      Regards,
      Mateusz.