Set Analysis - {<FieldA=FieldB>}

[Anonymous]

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

[sunny_talwar · Accepted solution]

May be this

Concat({<ID_2 = P(ID_1)>} Type)

[Anonymous]

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.