Solved: Template: Start expression + Select unique values - Page 2

JayG · 12-25-2023 06:28 AM

Hello,

While using SELECT statement with START expression, is it mandatory to use key column?

TblTest - Col 1 (key col), Col 2

This works - <<START: SELECT (tblTest[Col 1), TRUE)>> - But I want distinct values of Col 2

Doesnt work: <<START: SELECT (tblTest[Col 2), TRUE, TRUE)>>

Doesnt work: <<START: UNIQUE (SELECT (tblTest[Col 2), TRUE))>>

Please help!

Suvrutt_Gurjar

@JayG wrote:

While using SELECT statement with START expression, is it mandatory to use key column?

Yes, one needs to create a list of key columns within the <<START>> expressions

@JayG wrote:

This works - <<START: SELECT tblTest[Col 1), TRUE)>> - But I want distinct values of Col 2

You may want to try below, please create a slice on called say C2_Unique on the table with a filter expression something like

[Col 1]= MINROW("Table Name", "_ROWNUMBER", [Col 2]=[_THISROW].[Col 2])

Here [Col 1] is a key column.

Then your start expression can be something like

<<START: C2_Unique[Col 1]>>