Solved: Trying to get only instances where the Yes/No Cond... - Page 2

Nicolas_St-Laur · 02-12-2021 01:10 PM

Hi there,

I am trying a new approach to an issue I had previously.

Here is the issue: I am trying to get only the instances where ERG shows up in the TestID ERG List.

Here is my expression that I am using:

Creating a Virtual Column:
Select(TESTID List[Test ID], IN([RG_NAME], (SPLIT(TESTID LIST[ERG LIST],","))))

With this I am close, but I am getting the whole list of TESTID List[Test ID], I just want the intances where RG_Name appears in the ERG List and grab the Test ID when it appears.

Example:
Table: TestID List

Table: ERG_TechRole

Using the function above brings back all TestID’s, not just TS_Security

Any help is appreciated.

Steve

Try:

SELECT(
  TestID List[Test ID],
  IN([_THISROW].[RG_Name], [ERG List])
)

View solution in original post

Trying to get only instances where the Yes/No Condition exists