I cant seem to figure out what i'm doing wron...

(Matt Archer) #1

I cant seem to figure out what i’m doing wrong.

I have a Virtual Column to show information from another table and then concatenate the information. each expression works as a stand alone but i cant get then to work together.

=SELECT(PCH[PC #], [Proposal #]=[_THISROW].[Proposal #]), LIST(CONCATENATE(PCH[PC Vote]," ,",PCH[PC #]))

I want to select the correct information, then concatenate two columns and show the list.



PC Vote E1

Approve, PC1

Disapprove, PC2 E2

Watch, PC1 E3


Disapprove, PC1


Thank you!

(Syed Faheemuddin) #2

Try this. Create a virtual column in PCH table named [PC all] or something like that with formula CONCATENATE ([PC Vote], “,” ,[PC #], " ")

Now in the other table

CONCATENATE (SELECT (PCH[PC all],[Proposal #]=[_THISROW].[Proposal #]))

(Matt Archer) #3


Thank you! I had to add LIST to the beginning

LIST(CONCATENATE (SELECT (PCH[PC all],[Proposal #]=[_THISROW].[Proposal #])))

to get the complete lists but that was the solution i couldn’t see.

Thank you again Sir

(Syed Faheemuddin) #4

Happy to help🙂