Constructing a text statement based on Query data.

[Former Member]

Hello Friends

Is it possible to construct and display a text statement based on the query data in VC. What I mean is that the statement should extract words from the attributes in the Query output and construct a statement of words.

Thanks

[Former Member · Accepted solution]

String concatenation is possible in VC, you can use "&" to append two strings .

It will be easy if the output of a query is a single row than multiple rows.

You have to write a small formula which picks the output of the query and appends with other attributes in desired format.

[Former Member · Accepted solution]

Hey Jan

Thanks for your reply. Can you please elaborate in detail how it could be done. Also the output of my Query has multiple rows.

The situation is like this:

Consider the following output

<b>Project</b> <b>Phase</b> <b>Status</b>

XYZ A Green

<b>Statement</b>: Phase <b>A</b> of Project <b>XYZ</b> has a <b>green</b> status

[Former Member · Accepted solution]

I assume you want to change the text content dynamically as the user selection of rows change.

I have created a Wiki page refer the below link <a href="https://wiki.sdn.sap.com/wiki/display/VC/DynamicStringAppend">Dyn String generation</a>