This content has been marked as final.
Show 1 reply
-
1. Re: Selecting rows based on entry in multiple columns
Yuriy FalNov 23, 2018 8:05 AM (in response to Bradley Velasquez)
Hi Bradley,
The result could be obtained right in Tableau (Desktop)
by applying a Conditional Aggregate Filter.
The (row-level) filter calculation would be
IF [class] = 'PHY' THEN 1 END
The aggregation condition would be either SUM() > 0 or MAX() = 1
In Prep, there would be two steps (Aggregation and Join + Filter).
Please find the attached.
Yours,
Yuri
-
sample_data.csv.zip 220 bytes
-
Flow1_YF.tfl 3.4 KB