Insert a column with fixed value in a query

[Former Member]

Let's say i have a query:

Columns:

KF1

KF2

KF3

Rows:

Char1

Char2

Char3

Attribute1

Attribute2

Attribute3

Char4

So, after launching this query, it displays like this:

Char1 | Char2 | Char3 | Char4 | KF1 | KF2 | KF3 |

dsd sdsd sdd sdsd 34 34 56

sdsd fgfg ghgh yuyu 25 76 87

So, i need to insert a column between Char3 and Char4 That would have a title i want (let's say: "TEXT") and all the values of that column would be a set of characters, let's say: "R2"

[Former Member · Accepted solution]

I think you can try using a virtual characteristic.

[Former Member]

For this you should go for a structure in rows and put the chars. You can name it as you like again you can populate the data as required but where does the set of chars lie in the system? How do you want to populate them. If you want to populate(if not lying in the system) texts(values) you should then use some text variables I believe.

[Former Member]

Hi Kautroka,

Create a new characteristic use that constant value in it as "R2" and add that in your Info provider and drag the same in your query.

The name of that field can be changed as u need in the query.

Hope this helps u...

Regards,

KK.

[rajkumar_kandula]

Hi,

If this is the exact scenario try to create a dummy characterstic and map it to constant and insert it in the infoprovider on whcih u r building ur query.

Now while creating update rules for that infoprovider there also map that characterstic to coanstant valur(R2 here).

Now insert that dummy characterstic in rows in ur query definition.

I hope this works and let me know the same

Regards,

Rajkandula