transfer selection from multiple states to one state

[suryaa30]

Hi All,

I have below Alternate states

Alt_A,Alt_B,Alt_C

Currently I am transferring selections in Alt_A to Alt_C as show below.

Now I want both transfer selections made in both Alt_A and Alt_B together in Alt _C.

How should I manipulate the below expression.

='('&Concat({Alt_A}DISTINCT Replace([BankName],' ','?'),'|')&')'

[Anil_Babu_Samineni · Accepted solution]

how about this?

='('&Concat({Alt_A * Alt_B}DISTINCT Replace([BankName],' ','?'),'|')&')'

[suryaa30]

Is this intersection? I am expecting a union.

A= 1,2,3

B=4,5,

then 1,2,3,4,5 should be transferred

I came up with this.. will this do?

='('&Concat({Alt_A<Fecha+=P({Alt_B})>}DISTINCT Replace([BankName],' ','?'),'|')&')'

[Anil_Babu_Samineni]

For Union u need to specify +

[Anil_Babu_Samineni]

Try this?

='('&Concat({Alt_A<Fecha+=P({Alt_B} Fecha)>}DISTINCT Replace([BankName],' ','?'),'|')&')'

[sunny_talwar]

How about this

='('&Concat({Alt_A + Alt_B}DISTINCT Replace([BankName],' ','?'),'|')&')'

[suryaa30]

I used +