Here is the query I wrote, and it works correctly in the database. But it doesn’t work in Tableau Prep. How do I rewrite it? What are the syntax rules to make it work?
WITH Duplicates AS
(
SELECT player_id
FROM player_agg
GROUP BY player_id
HAVING SUM(reg_cnt) = 2
AND COUNT(DISTINCT license) = 2
),
FilteredRows AS
(
SELECT m.*
FROM player_agg m
JOIN Duplicates ip ON m.player_id = ip.player_id
WHERE (m.reg_cnt = 1 AND m.license = 'COM')
OR m.reg_cnt <> 1
)
SELECT *
FROM FilteredRows
Working query in tableau prep