Solved: Group By + Select + suggested value - Page 2

rrhirani · 01-07-2020 02:19 PM

I am writing one expression which gives me unique value of column but I want result associated with second column.

SELECT(Task[Task(s)],[Organization] = “A”)

Above expression gives me the result (In dropdown)
Task1
Task2
Task3
Task4
Task5
Task6

but I want the result as
Task1 - Section 1
Task1 - Section 2
Task2 - Section 1
Task2 - Section 2
Task3 - Section 1
Task4 - Section 1
Task5 - Section 1
Task6 - Section 2

I need a similar solution as in MySQL

SELECT CONCATE(Task(s),’-’,Section) FROM Task WHERE Organization = “A” GROUP BY Task(s),Section

Any suggestions would be great. Thanks

LeventK

@rrhirani
You cannot create it with a SELECT expression. I may advise structuring a Virtual Column in that table with simple CONCATENATE expression first:

CONCATENATE([Tasks(s)]," - ",[Section])

And then call this column in your Suggested Values:

SELECT(Task[VirtualColumnName],[Organization]="A")

View solution in original post