Skip to Content
author's profile photo Former Member
Former Member

Concatenation of two rows

Hi

i have an object level1 in that have data is

software

subscription

not assigned

i want to apply the prompt funtion in universe level for this object

my data is will look like

software

subscription

software & subscription

is it possible ,if it possible can you please tell me the septs

Advanced thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2010 at 08:05 AM

    Hi,

    Which data source are you using?

    The answer is dependent of the data source.

    Didier

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Didier

      Thanks for Quick Reply

      My requirement is "software & subscription" is not substitute for "not assigned"

      and also if i apply the prompt for this object i want to see all the like

      Software

      Subscription

      Software & Subscription

      Notassign

      How it implement Can you please tell/stepts

      Thanks in Advanced

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2010 at 12:05 PM

    Hi,

    Do you to create an additional row that is the "aggregation" of software & subscription?

    If this is the case, you cannot do it at the query level that way.

    You have to do it at report level. I don't think there is an easy to do it at universe level.

    What is the final goal in your document for doing this?

    Didier

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Actually you have to use the following query for the LoV object:

      SELECT <Object name> FROM <Table> (Default query geneartion of the object)

      UNION

      SELECT "software & subscritption"

      Try running the above query directly on the database to get the desired result and if it works you can directly paste it in

      the object prop. and save the sql.

      Rest code is fine and don't need any change. If you still find the error can you please give me the code you are using.

      Regards,

      Rohit

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2011 at 07:01 AM

    Thanks every one it's resolved ....

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.