Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In my expression I am trying to do a CONCAT with set analysis. I have two loaded tables not connected to each other.
ID_1 | Data |
---|---|
123 | 100 |
456 | 200 |
ID_2 | Type |
---|---|
123 | AAA |
User first selects an ID_1. There should then be a straight table showing ID_1 and Type.
So what I've done is create a Straight Table with Dimension = ID_1 and Expression is CONCAT({<ID_2=ID_1>}Type). The set analysis isn't working. But basically I want to get [Type] from the other table where ID_2 is equal to the selected ID_1.
Note that I cannot rename ID_2 as ID_1 in the load because ID_2 does not consistently refer to ID_1. For other rows ID_2 contains values for other types of ID's.
Resulting Straight Table:
ID_1 | Type |
---|---|
123 | AAA |
May be this
Concat({<ID_2 = P(ID_1)>} Type)
Thanks Sunny. The above from experience seems to work occasionally. For this instance, I decided not to use set analysis and just tried:
=Concat(if(ID_2=ID_1,ActivityName))
and worked okay.