Union of two fields into single column in Straight table

[#1]

Dear All,

I have table with two fields like :

Region	Comp
A	1
A	2
A	3
B	4
B	5
C	6
C	7
D	8
D	9

Now I want to Create a table in which the dimension should be the combination of these two fields into one:

Location
A
1
2
3
B
4
5
C
6
7
D
8
9

Is this possible at front end?

Thanks in advance.

[swuehl]

I believe you can't easily create a concatenated field that is associated with your data model on the front end.

What you can do, is create a synthetic dimension using ValueList(). But this would probably require some logic also in your expressions to filter your data according the synthetic dimension value (could be done using pick() / match()).

But I would suggest remodelling your data.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw for the useless trick. Remodel your data for a real solution.

[tresesco]

Or,

Like in attached sample using valuelist(). But seems not a useful one in real life scenario.

[rbecher]

Hi Shrasti,

you could use an expression like:

Region & '/' & Comp

..and treat it like an hierarchy (see attached example). But then you cannot select region.

- Ralf

[rbecher]

What? Hehe, funny how useless...